SQL: No process is on the other end of the pipe

Share this article :


You want to connect to the SQL database but ended with below error,

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

SQL - No process is on the other end of the pipe


• Ensure both SQL Server and SQL Server Agent are running. You can determine from the Windows services or SQL Server Configuration Manager.

• Ensure the TCP/IP protocol is enable. You can enable the protocol via SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER.

• Switch the authentication, try to login with Windows Authentication / SQL Server Authentication. Use sa username and password if you have the access.

• Refer to MSSQL: Cannot open user default database. Login failed.

Related posts

Stop & Start MSSQL Server 2005
Find MSSQL Server Start Date & Time
Restore of database 'SID' failed. Exclusive access could not be obtained because the database is in ...
How to Enable MSSQL Backup Restore to Mapped Network Drive
© 2017 ITsiti. All Rights Reserved
Powered by KEEM