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???
Error 21776: (SQL-DMO)The name 'dbo' as not found in the Users collection.
How can I solve this problem???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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)
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
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
I am in a similar situation --- did you reinstall and how did it work out for you?
Appreciate your feedback and thanks!
Hapy3sum