This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 50%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZW%3C/text%3E%3C/svg%3E)
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.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 91%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVJ%3C/text%3E%3C/svg%3E)
Hi @Zac Watkins , Hope your problem is resolved, if not Please change the security property of the Server to SQL Server and Windows Auth mode.
Required Path : Server (Right Click) -> Properties -> Security -> Server Authentication -> SQL Server and Windows Authentication Mode.
Last but not least please verify the user/s are enabled before trying the connections.
Thanks ,
Vijay Jadhav
Upvote if it works for anyone :)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 17%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
I had this error turned out there were 2 SQL Server Logins both the same 1 in the Security Users and 1 in a restored Database. 1 App would connect the other App would throw this error even though the Connection String was the same in both Apps. SQL User Account same password both should have failed or both worked. Removed the SQL Account from the restored Db. Added the SQL Account of the same name and Password to the Db all Apps connected and worked.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 50%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
I got this error While using PPDM (PETA POCO (Micro ORM)) and the issue was : I Passed Mandatory date field as 'NOTHING' by mistake, But the Orm Chose this error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 25%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
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"!!!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 78%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
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.