Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old December 1st, 2003, 05:11 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default forgot sa password, unable to change... help

Hi,

I forgot my sa password and was using normal user account to open EM for a long time. Now I wanted to login to EM or Query analyser using SA, since BULK INSERT is not allowed for logins other than sysadmin role.

I tried from EM, to use WINDOWS NT Authentication, and tried changing the password for sa, and was getting an error as follows.

"Error 21776: [SQL-DMO]Then 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 checked for dbo in sysusers table and it exists there. Not sure what it means or what I should do now to change the password for sa.

I was trying to change the password for sa from the EM, by editing properties of sa.

Is there anyother way to change the password. Pls help me out.

Thanks,

-Vijay G
__________________
- Vijay G
Reply With Quote
  #2 (permalink)  
Old December 1st, 2003, 09:13 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

Umm, I thought you needed sysadmin role in order to change a password without knowing the original one.

If your "normal user account" is a Windows NT account, then making that account a local admin on the PC should give it sysadmin rights.
Reply With Quote
  #3 (permalink)  
Old December 1st, 2003, 09:54 AM
Registered User
 
Join Date: Sep 2003
Location: , , Greece.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Not sure what you 've done really,
your best bet is to try to unregister your sql server off your enterprise manager and reregister it, and use Windows authentication model. If that won't work, unfortunately, you're heading for a master db backup, however, you will need to restore the system dbs (msdb,model) and your working dbs, because this means your server will be cleaned.

-- edited --

Also from a website I found this :

Quote:
quote:
To reset the sa password, you can make the following:

1. Login to the SQL Server box as the Administrator.
2. Run SQL Server Enterprise Manager.
3. Right-click the server name and choose 'Edit SQL Server Registration properties'.
4. Choose 'Use Windows authentication' and click OK button.
5. Expand a server, expand a Security and click Logins.
6. Double-click the sa login and specify new password on the General tab.
Reply With Quote
  #4 (permalink)  
Old December 2nd, 2003, 01:11 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

I am always logged in to that system using windows Administrator account. After which I tried changing the password, and got that error mentioned in that mail.

-Vijay G
Reply With Quote
  #5 (permalink)  
Old December 2nd, 2003, 01:47 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

I unregistered and re-registered the sql server from EM to use windows authentication this time again, but no luck. Still when I tried to change the sa password, I get the same error I posted in the first post.

Any other work around left


-Vijay G
Reply With Quote
  #6 (permalink)  
Old December 2nd, 2003, 04:43 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:Originally posted by happygv
 I am always logged in to that system using windows Administrator account. After which I tried changing the password, and got that error mentioned in that mail.

-Vijay G
But if you are already logged in as windows administrator you should have sysadmin rights, so you should be able to do bulk insert, so you shouldn't need sa account...
Reply With Quote
  #7 (permalink)  
Old December 2nd, 2003, 05:03 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Yes, you are right. I am already able to connect to query analyser using windows authentication. But I am not allowed to login as administrator from anywhere or no one else is allowed to use this administrator account. On request, on a temporary basis I have been allowed to use administrator account till I resolve the sa password issue. So my concern is to somehow change the sa password and take off from there.

Thanks for your time and effort.

Cheers,

-Vijay G
Reply With Quote
  #8 (permalink)  
Old December 2nd, 2003, 01:53 PM
Authorized User
 
Join Date: Jun 2003
Location: , , Romania.
Posts: 77
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try to use directly the sp_password stored procedure from Query Analyzer. Maybe it will work this way. (I took a look at the code EM generates when you try to change a password, and it uses sp_password).

defiant.
Reply With Quote
  #9 (permalink)  
Old December 3rd, 2003, 02:26 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Well, thatz not a bad idea, still I need to remember my old password for doing so.

:(

-Vijay G
Reply With Quote
  #10 (permalink)  
Old December 3rd, 2003, 02:37 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

I should anyways Thank "defiant"

When I tried using sp_password with different OLDPASSWORDs, I got the password changed for the SA.

You made me remember my old password somehow. Actually I tried changing with the both the old and new passwords as same word, and it said the password was changed. To my wonder I have tried the same password manytimes earlier and failed to login. Not sure what went wrong. But now I am able to login using sa.

Thanks a ton. For everyone who tried their hands on this. You all really got pulled out of this.

Cheers,:D

-Vijay G
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
FORGOT EXCEL PASSWORD prasanta2expert Excel VBA 4 March 17th, 2010 05:23 AM
Chapter 7 Email setting for "forgot password?" hdpark BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 10 April 23rd, 2008 02:48 PM
sa password ckentebe SQL Server 2000 2 January 5th, 2005 05:34 AM
Forgot password for phpmyadmin AMP_Engineer BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 3 September 8th, 2004 04:59 AM
Forgot password? developerz BOOK: ASP.NET Website Programming Problem-Design-Solution 1 November 30th, 2003 04:36 PM



All times are GMT -4. The time now is 11:50 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.