I need to change the sa password on one of my sql servers. When I tried to do it from Enterprise Manager I got the following message "Error 21776: [SQL-DMO] The name 'dbo' was not found in the Users collection. If the name is a qualified name, use [ ] to separate various parts of the name, and try again."
I could change it in Query Analyzer with sp_password, but then could not access the DTS packages, even though I had changed the database connections in them to use a different login name. Anyone know what I missed?
HI,
Do the Following steps to change the sa password.
1) Enter in to the required server in the enterprisemanager.
2) Select the security --> logins
3) right click on the sa available on login page and goto properties
4) Go to server roles tab and check whether the system administrators is selected or not.If not selected, select it.
5) Then move to general tab and enter your new password.
6) It will ask for confirm password, enter password again and click apply.
7) Now you can login with the password you entered.
Post me if u faced any issues on that.
with luv,
sudhir