Tips, Tricks, News & Offers
If you would like to be kept up to date with Internet technology changes, Idaq technical tips & How To's plus discounts and special offers, subscribe to our Tips, Tricks and offers Newsletter:

Email:
First Name:
Last Name:
Knowledgebase: Windows
How to change an MSSQL administrator password?
Posted by Matthew Whittaker on 20 June 2006 12:21 PM
Go to the command prompt:

for a local server use:
osql -E -Q "exec sp_password NULL,'new_password','sa'"

for a remote server use:
osql -S servername_or_address -E -Q "exec sp_password NULL,'new_password','sa'"

Note: Your account must have administrator rights on the server.

(39 votes)
This article was helpful
This article was not helpful

Comments (0)
Post a new comment 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Hosted by Idaq