I Have got a problem with my sql server 2005 ,im doing one projet in
visual studio 2005, when i am saving the datas from my form they keep
one error message that"An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005,
this failure may be caused by the fact that under the default settings
SQL Server does not allow remote connections. (provider: Named Pipes
Provider, error: 40 - Could not open a connection to SQL Server)"
what can i do for this?
Loading
Jojo Jose PrakashPosted Jun 2, 2009, 4:53 AM
paiha paigaPosted Oct 30, 2008, 4:41 AM
First of all See the Menu of your visual studio .NET2005 and click on the
Menu Tools and select the options Connect to DataBase full fill the open wizard on the basis of your requirement i.e by giving DataSource ,Server Name etc. you can click the radio button either
Use Windows Authuntication or Use SqlServer Authontication on the basis of your database place.and then after click the button ok and maintain the connection
Now See the Server Explorer and select that one.Then you will see the Data Connections icon and his child icon that will be your connection string so Right click on the child icon and go to the Properties option then you see the connection just bring the cursur over the Connetion String option and Copy the string there will be data sourse , Initial Catalog, Integrated Security , provider available.Just maintain every thing in Web.Config file according to the value of the connection string given, you can make the connection through the database.
Thanks
Kirtan PatelPosted Oct 30, 2008, 4:30 AM
To Enable Remote Connection
Go To
Start >> SQL Server 2005>>Configuration Tools>>SQL Server Surface Area Configuration>>Surface Area Conflagration For Services and Connection >>Remote Connections
Select "Using both TCP/IP or Named Pipe"
Restart SQL Server Service or Computer
Now Connect to Database :)
Happy Coding :)