473,322 Members | 1,403 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Error 21776 when I change the sa password in sql server 2000

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?
May 10 '07 #1
2 3227
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
May 24 '07 #2
I had the same problem. Your databases may not be refreshed after you made the change. Simply close out Enterprise Manager total and then open it again.
Jan 10 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Wayno | last post by:
My php logs are coming up empty. I have done all I can think of, and all that made sense to me. Can someone take a look at my php.ini please and tell me what you think may be the problem. I...
2
by: Patrick | last post by:
Hello I have 3 Servers, all running Windows 2000. On two (WEB-1 & WEB-2) machine I run a website with IIS 5.0 and on the other an MS SQL Database 2000 (SQL-01). So I connect from the Websites...
5
by: Dave | last post by:
I reinstalled SQL 2000 server after reformatting my drive. Now I cannot open a database in my C## program as before. If I use "Provider=SQLOLEDB;Data Source=localhost; Initial...
5
by: Ken Cox [Microsoft MVP] | last post by:
MS has posted this here: http://www.asp.net/faq/ms03-32-issue.aspx Fix for: 'Server Application Unavailable' Error after Applying Security Update for IE...
2
by: Ken Agustin | last post by:
Hello: When I try to access a web page on a Windows 2000 server with IIS 5.0, FrontPage Extension, Microsoft Visual Studio.Net, I get the following error message: ...
13
by: Edward Mitchell | last post by:
I have a problem that involves the error I receive when attempting to complete the asp.net web application example (Walkthrough: Creating a Web Application Using a Third-Party Business Object). ...
6
by: rn5a | last post by:
During registration, users are supposed to enter the following details: First Name, Last Name, EMail, UserName, Password, Confirm Password, Address, City, State, Country, Zip & Phone Number. I am...
1
by: jshunter | last post by:
I've recently migrated all databases to SQL Server 2005. I couldn't figure out how to create an SSIS package in the time I had, so I just stuck with the DTS packages. They all worked fine during...
5
by: Alan Silver | last post by:
Hello, Server configuration: Windows 2003 Server SP2 SQL Server 2000 SP4 ..NET v2.0.50727 just built up a new server using the same configuration as my current one. I even used the same CDs...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.