Question Locked

How can I recover or reset my SQL 2005 sa user password?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I recently installed SQL 2005 on my SBA server 2003. I have attached a number of DB's to it, and have since been running it without problems for 5 months now. I recently was tasked to install new software which is requiring sa user admin password. I never set one, thus in theory it should be blank by default. I tried CMD prompt to test and used osql -U sa
password:

received the following error:

"[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect())."

Looking into it, I think I may have an instance issue? I am puzzled at this point since my other programs can see SQL running and can connect to it. Ideas?

2 replies

by tony hopkinson

You can only log in as sa if you have sql security on (default is integrated security).
So you need to switch the security mode to mixed.
Run up sql server manager, right click onm the server, elect properties it's in there somewhere.

Sa should be in your list of logins, you need to enable it and set a password, after that you should be golden.

I'm pretty sure sa password will not be blank set up or not, at least I hope it never is.

This discussion is closed to new replies.