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
This didn't work
ReplyDeleteThis didn't work
ReplyDeleteHi All,
ReplyDeleteI 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!
ReplyDeleteRecently I came across an issue when connecting to SQL Server instance using SQL Authentication.
ReplyDeletehow to use cricut heat press for shirts
best cricut to make stickers
cricut sunflower
cricut gifts for dad
different types of vinyl for cricut
flower images for cricut
design for cricut
cricut award ideas