SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Map Windows Login to SQL Login
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

billhealy
Starting Member

USA
1 Posts

Posted - 12/26/2012 :  11:21:53  Show Profile  Reply with Quote
New administrator here. I have an application which has an admin SQL account that handles a bunch of automated tasks for the application. From time to time the users have to login with this account and do some maintenance. The things they need to do can ONLY be done with this special admin account.

The users have lost the password for this admin account. If I change reset the password I will "break" many of the functions of this application and they will be forced to reinstall the app.

Is it better for me to try to crack the password with one of the brute force crackers out there or is there a way for me to map one of the windows login users to this admin SQL user account so that they can login as themselves and be able to do what they need to do? Or perhaps there's another option I'm not aware of.

Thanks in advance for any help.

mandm
Yak Posting Veteran

86 Posts

Posted - 12/26/2012 :  12:38:03  Show Profile  Reply with Quote
It might be easier to make a new Admin account with the same characteristics as the original and have the users move to that. Keep the password in a safe place so it doesn't get lost again.
Go to Top of Page

prett
Posting Yak Master

USA
205 Posts

Posted - 12/27/2012 :  00:10:27  Show Profile  Visit prett's Homepage  Reply with Quote
You have two options to reset your password:

Option 1 : If there is any other SQL Server Login that is a member of sysadmin role, you can log in using that account and reset the password of SQL Server. As described in the bottom post link.

Option 2 : If there is any other Windows Login that is a member of Windows Admin Group than you can login account using same. Start SQL Server in Single User Mode as described in the bottom post link.

Ref: http://blog.sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000