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

By jaron22 ·
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 <enter>
password: <enter>

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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Two things

by Tony Hopkinson In reply to How can I recover or rese ...

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.

Related Discussions

Related Forums