Hello. Thanks for visiting.

Have questions about Server Intellect?

I'm here to help.

Call us toll free at 1-855-850-HOST(4678)

Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

Resetting the SA Password for SQL Server

Resetting the password for your SQL Server 2005 ‘sa’ user (abbreviation for ‘System Administrator’) can be done in a few quick steps through SQL Server 2005 Management Studio, both Standard and Express Editions.

For the purposes of this article, we will demonstrate changing the ‘sa’ password from within Management Studio Express, as there is relatively no difference between the versions concerning altering the ‘sa’ password.

Step 1

Open SQL Server Management Studio by navigating to Start -> All Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express.

kb-sql-reset-sa-pw-1

Step 2

Connect to your instance of SQL Server via Windows Authentication.

kb-sql-reset-sa-pw-2

Step 3

Once open, in the Object Explorer view, click the plus sign next to Security, and then the plus sign next to Logins. Once expanded, right-click on the ‘sa’ user, and choose Properties.

kb-sql-reset-sa-pw-3

Step 4

In the Properties window which opens up, on the first page you will see two fields containing a masked password. Type in your preferred password and click OK.

kb-sql-reset-sa-pw-4

You have now reset the ‘sa’ password for your instance of SQL Server 2005. Please note the password change for your records, as remote administration of your database relies heavily on this particular user.

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.