Why does my sa account on SQL Server 2008 keep getting reset

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 ?

Thanks,
Sudeep
cranialsurgeAsked:
Who is Participating?
 
dportasConnect With a Mentor Commented:
Are you capturing failed logins to the event log? Check that your SA login isn't being hacked causing lots of failed password attempts.

Avoid using SA at all. Use a domain login with the sysadmin role or create a different admin login called something other than SA.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.