In my case the reason was none of the above. The SQL user I had in my connection string was removed from the database. As soon as I added it back, the application started working. I really wish that SQL Server gave an error something like "The user xxx does not exist"!!!
Fixing Error 0: No process is on the other end of the pipe.
Recently trying to work on some SSRS stuff with a local instance of my company Database, and I messed with number of allowed connections. Now attempting to connect to my local instance yields:
Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Failed to connect to server DESKTOP-68S3Q92. (Microsoft.SqlServer.ConnectionInfo)
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
No process is on the other end of the pipe
Interestingly, if I restart my server from SQL Server Configuration Manager it will successfully connect, but then immediately give the same message, and prevent me from touching properties or anything else.
If anyone has some insight to the problem I would be most appreciative, I'm still pretty new at this SQL game.
7 answers
Sort by: Most helpful
-
-
Lucas Barros 0 Reputation points
2023-04-22T15:53:37.7766667+00:00 to me, i need to insert a user inside the database, note that, you need to first insert the user on the server, then in the database. another think is change the login to sql users and windows users too. to create the user in the server go to security bellow the server name ->logins/logons(depending for your language) to create the user in the database, go to the database -> security -> users.