Visual Studio can't add SQL database

Article
2010-03-04

Question

_{Thursday, March 4, 2010 9:21 AM}

Hi...

I want to add database to my website but it shows the error that

A network-related or instance-specific error ocuured while establishing connection to SQL server. The server was not found or not accessible. Verify that the instance name is correct and that SQL server is configured to allow remote connections. (provider: SQL network interfaces, error:26-Error locating Server/Instance specified).

I have uninstalled the visual studio and installed it again but it still shows the error..

kindly please help me out...its very very urgent...please..

All replies (7)

_{Thursday, March 4, 2010 9:41 AM ✅Answered}

Using the SQL Server Management Studio from the same machine as your Visual Studio is installed, are you able to connect to a SQL Server database?

Also, take a look at this KB article: http://support.microsoft.com/kb/914277

_{Friday, March 5, 2010 12:24 AM ✅Answered}

refer this:

http://forums.asp.net/t/1505801.aspx

http://www.sqlmusings.com/2009/03/11/resolving-a-network-related-or-instance-specific-error-occurred-while-establishing-a-connection-to-sql-server/

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

_{Friday, March 5, 2010 6:51 AM ✅Answered}

refer this:

http://support.webecs.com/KB/a204/how-do-i-connect-to-sql-server-using-visual-studio-net.aspx

were u able to conect

_{Friday, March 5, 2010 12:31 PM ✅Answered}

My guess is that you do not have the necessary SQL Server support files for Visual Studio to work properly. If you do not have SQL Server installed, then download SQL Server 2008 Express with Advanced Tools and install it. You should be able to get Visual Studio working after that.

_{Saturday, March 6, 2010 6:32 PM ✅Answered}

I have had this error before when trying to run a SQL Express database located on a network share.

Depending how you are connecting to the database, after you have re-installed SQL Server so you have the configuration tool, try enabling named pipes and make sure tcp/ip is enabled.

_{Friday, March 5, 2010 3:58 AM}

Thanks for ur reply..

I am not able to connect to SQL Server though visual studio is installed in my laptop.

And in the link given, it says goto start->programs->microsoft SQL Server.. but i dont have that in my laptop..

What should i do??

please help me....

_{Friday, March 5, 2010 4:03 AM}