error while connecting to sql server

Krunal Parate

11y1.5k

im getting ti error how to solve this??

TITLE: Connect to Server
------------------------------

Cannot connect to LENOVO-PC.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

5 Replies

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

Dazy Parker11y ago
There are many solutions on the web. As your error number is 2 then follow the steps of this article:

https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/

Good Luck!
Vinodh Narayanan11y ago
Dear krunal.

Please check the specific database service is running or not.

Check your SQL Service instance service is running or not on the windows services

Go to Run -> Type Services.msc scroll down and see the Sql Server database engine services running or not and check for the database instance you created

"Please mark if accepted as a answer"

Regards
Vinodh,N(SharePoint developer/Administrator)
Sujeet Suman11y ago
Krunal there many cause to failure of database server connection.

So please once go through below link & checkout your problem:
https://technet.microsoft.com/en-us/library/ms156468(v=sql.105).aspx

If this is helpful for you then please accept my Answer.
Raja T11y ago
Hi, Please check out bellow URLs

http://www.technologycrowds.com/2014/02/could-not-open-connection-to-sql-server.html?m=1

http://blog.sqlauthority.com/2007/04/23/sql-server-fix-error-40-could-not-open-a-connection-to-sql-server/

https://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/
Manas Mohapatra11y ago
There are multiple reasons to get "instance error", please go through below check lists:

Option 1: Make sure that you are providing correct credential.

Just cross check, you are selecting correct authentication mode like Windows/Sqlserever. And providing correct server name.

Option 2: Make sure that your server is running because sometimes it shutdown.

Run command(Windows icon + R) -> services.msc -> Go to SqlServer Inastnace and check whether it is running mode. If it is not running then start it.

Option 3: If your data base is hosted in other than your machine then make sure that you are able access that machine by using ping command in Command prompt.

If you are still getting error please restart machine and let's see.