Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

No Process Is on the Other End of the Pipe

I receive this error when I try to connect to SQL Server 2005. I have enabled TCP/IP, Named Pipes, and restarted the server but that is not working.

like image 358
Sheehan Alam Avatar asked Jan 16 '09 19:01

Sheehan Alam


People also ask

How do I enable mixed mode authentication in SQL Server?

Change authentication mode with SSMSIn SQL Server Management Studio Object Explorer, right-click the server, and then click Properties. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.


2 Answers

For me the issue was that the SQL server was in Windows Authentication mode only, even though I set it to mixed during the install.

In the object explorer, right click on the server, properties and then the Security page and set Server authentication to SQL Server and Windows Authentication mode.

like image 164
Adam Avatar answered Sep 19 '22 05:09

Adam


I tried the troubleshooting steps in both microsoft tech articles, and oddly no luck.

I managed to fix the solution by changing my authentication from SQL Server Auth to Windows Auth. Though I am not sure the technical reason why this works?

like image 31
Sheehan Alam Avatar answered Sep 21 '22 05:09

Sheehan Alam