Provider named pipes provider error 40 could not open a connection to SQL Server error 2

user_2536611 0
Viewed 68057

When I am trying to connect to my database in SQL Server Management Studio, I getting this error:

Provider named pipes provider error 40 could not open a connection to SQL Server error

After checking several answers on SO, I opened the SQL Server Configuration Manager

I found SQLSERVER (SQLEXPRESS) and all three options state >> STOPPED

I tried it starting by right clicking on it, but i got below error:

The request failed or the service did not respond in a timely fashion

How can I connect to the instance???

sql-server c#
9 Answers

This error has caused been popping up for me since installing .net 4.7 I had to alter my connection string to include TransparentNetworkIPResolution=False;

Server=server;Database=dbname;Uid=user;Pwd=pword;TransparentNetworkIPResolution=False;
user_26826620
Related