A connection was successfully established with the server, but then an error occurred during the login process. | SansSQL

Friday, August 22, 2014

A connection was successfully established with the server, but then an error occurred during the login process.

Recently I came across an issue when connecting to SQL Server instance using SQL Authentication.
The error says,
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)


To fix the issue, Disable "Shared Memory" protocol in the SQL Server Configuration Manager.


To find the status of SQL Server Protocols using T-SQL, refer to the below link
http://www.sanssql.com/2011/04/t-sql-query-to-find-sql-server.html

4 comments:

Austin said...

This didn't work

Austin said...

This didn't work

wael abed said...

Hi All,


I faced the same issue once and what I did was

1. I stopped all other services (Analysis, integration and reporting services) and restarted the MSSQLSERVER service.
2. Then I was able to connect to database engine using SSMS.
3. Properties > Connection > Changed the value into 0 (Unlimited).

Binyam Tilahun said...

In my case I changed the connection mode from windows authentication mode to SQL Sever and Windows Authentication mode.Then it works!

Post a Comment