We help IT Professionals succeed at work.

Change SQL Server 2005 password for SA

Medium Priority
407 Views
Last Modified: 2012-05-07
We have misplaced the password for user SA in our SQL2005 with SP2.

However, I have a user that connect successfully via windows authentication.  But can connect via SQL USer/Password.

Is there a way the user with authentication can go in ans change the SA password?

IF not, what woould be the process to change the password.  The SQL2005 is installed in a server 64 bit, 6 gb ram, dual core.

Comment
Watch Question

AneeshDatabase Consultant
CERTIFIED EXPERT
Top Expert 2009

Commented:
ALTER LOGIN SA  WITH PASSWORD = '';

Commented:
Is the user that can login setup as a sysadmin?  If not, then verify whether or not the BUILTIN\Administrators account has been inactivated or sysadmin has been removed.  If not, then you should be able to add a domain user to the Administrators group on that server, login using that windows users and change the SA password.
If none of that works, then your only option is going to be starting up in single user mode and using DAC to access the server and change the password.

Author

Commented:
ok...we 'll try both...thanx!

Author

Commented:
Hi,

Non worked.  Can u please describe the DAC option?

Thanx!

Commented:
What do you mean it did not work?
Is the BUILTIN\Administrators login active in SQL Server?  What were the exact steps that you tried, and how did they not work?  Did you get any error messages?

Author

Commented:
Sorry about that...I meant that the user is setup as a sysadmin and also BUILTIN\Administrators account is inactivated; I didn't have to make any changes.

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
THANX!!!!!!!!!!!!!!!!!!

Author

Commented:
Worked Excellently !
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.