Fixing Error 0: No process is on the other end of the pipe.

Question

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.

Answer 1

In all likelihood, your SQL server login is locked out.

• In SQL Server Management Studio, login into the server with a Windows account.
• Expand the Security Tab, right-click the account in question and choose Properties.
• Click "Status" and see the checkbox labelled "SQL Server Authentication".
• If the "Login is locked out" is checked, uncheck it.
• It may prompt you to reset the password. Click the General tab, reset the password (can be the same as teh old one)
• hit OK and you should be all set.

Answer 2

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.

Answer 3

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"!!!

Answer 4

Hi,

In my case, Login was set it up only as Windows user, therefore I could not login as SQL Server user. I could not find out how or who did the change. Anyway, I found a way to fix it by changing the Loginmode thruogh the registry.

Open the registry and go to HKLM \ Software \ Microsoft \ Microsoft SQL Server \ <instance> \ MSSQLServer \ LoginMode
then change the value to “2” for the mixed mode.

Restart SQLServer services. Now you should able to login as Server user

Regards

Answer 5

hello everyone i had the same problem and i solved it by disabling password expiration,
I hope this will help

Disable password expiration on SQL user login

1. Open SQL management studio
2. Login with an appropriate admin-level account (using either Windows or SQL authentication)
3. Expand Security – Logins
4. Right click the desired login and choose properties
5. Untick enforce password expiration
6. Choose OK