Link to home
Start Free TrialLog in
Avatar of gfactor
gfactor

asked on

sa Password lost - now what???

We've lost our sa password. When you try to change it with another ID it gives the following error:

Error 21776: (SQL-DMO)The name 'dbo' as not found in the Users collection.

How can I solve this problem???
ASKER CERTIFIED SOLUTION
Avatar of dredge
dredge

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dredge
dredge

oh yeah, after you reinstall SQL Server, use sp_attach_db to reattach your databases to the server.
here's a great article on Disaster recovery for SQL Server.

http://support.microsoft.com/support/kb/articles/Q169/0/39.ASP
If you have NT authentication enabled you should be able to logon as a local administrator and then change the sa password (this assumes that builtin admins has not been removed from SQL)
Avatar of gfactor

ASKER

Hi,

thank's for the responses. I tried using the NT local administrator account and I'm still not able to change the sa password. Looks like I'll have to reinstall SQL Server.

Thank's again
Gfactor,

I am in a similar situation --- did you reinstall and how did it work out for you?

Appreciate your feedback and thanks!

Hapy3sum