Why does my sa account on SQL Server 2008 keep getting reset
Posted on 2009-04-12
I have SQL Server 2008 setup on my server and am facing an issue wherein, each time I restart the server and try logging in to the DB using the "sa" credentials I get the following 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.) (.Net SqlClient Data Provider)
I have to reset the "sa" account each time I restart in order to get rid of this error using
ALTER LOGIN sa WITH PASSWORD = 'new_password' UNLOCK
Any idea what might be going on here ?