A network related or instance specific error in sql server

Question

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

Pankaj Pandey · Answer

then please upload here your code if possible.

NAGARAJU TAMADA · Answer

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

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

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

Hi, Please refer the below link http://www.aspdotnet-sharepoint.com/2012/04/network-related-or-instance-specific.html Regards, Iftikar

Ravi Shekhar · Answer

Check your connectionstring

Sanjeeb Lenka · Answer

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/

A network related or instance specific error in sql server

Answers (7)