A network related or instance specific error in sql server

NAGARAJU TAMADA

13y2.3k

A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Name Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

Please Solve My Problem

This Problem occured again and again in my sqlserver Please give reply to me

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pankaj Pandey13y ago
then please upload here your code if possible.
NAGARAJU TAMADA13y ago
All are used the same properties already.All re working properly.but suddenly problem occurred.The problem arrives when I Open SqlServer but not in Running The project

please Reply to me

Regards
NagaRaju T
Pankaj Pandey13y ago
please check your sqlserver name in connection string.

And also check that your sql server is running or not by connect sqlserver manually.

open sqlserver ,insert server name,user id and password..and check that ur sql server is connected or not.
NAGARAJU TAMADA13y ago
Thanks for ur answer sir,

But When I click on "SQL Sever Services" It displays "The Remote Procedue call failed" Please Solve my problem
Iftikar Hussain13y ago
Hi,
Please refer the below link

http://www.aspdotnet-sharepoint.com/2012/04/network-related-or-instance-specific.html

Regards,
Iftikar
Ravi Shekhar13y ago
Check your connectionstring
Sanjeeb Lenka13y ago
refer to this link:

http://blog.sqlauthority.com/2008/08/24/sql-server-fix-error-40-could-not-open-a-connection-to-sql-server-fix-connection-problems-of-sql-server/