I CAN'T CREATE CONNECTION WITH MY DATABASE

Question

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?

Jojo Jose Prakash · Answer

I LOVE U DARLIN...............................

paiha paiga · Answer

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 Patel · Answer

Make Sure that U have Enabled Remote Connection In SQL Server Configurations 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 :)