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