Networking, Programming and Graphics Tutorials

How to reset MSSQL sa user password with Enterprise Manager [1/1]

Type: Picture Networking, Programming and Graphics Tutorials
How to reset MSSQL sa user password with Enterprise Manager
Level: Beginner Networking, Programming and Graphics Tutorials 
How to reset MSSQL sa user password with Enterprise Manager
Date: 2007-Apr-07
How to reset MSSQL sa user password with Enterprise Manager
Visited: 2732 times
How to reset MSSQL sa user password with Enterprise Manager
Rating: How to reset MSSQL sa user password with Enterprise Manager
How to reset MSSQL sa user password with Enterprise Manager
Author: Stephen Think

This tutorial will show you how to change/update/reset the password on the 'sa' account from the graphical interfaces of MSSQL Server 7.0 and 2000 or MSDE.

Start by opening the Enterprise Manager. This is usually located here:
Start -> Programs -> Microsoft SQL Server, but your software may be configured differently.

Starting with MSSQL , the SQL Server Enterprise Manager is a snap-in for the "Microsoft Management Console" (mmc.exe). Check the Microsoft documentation if you are unsure how to use this application.

Navigate to the Logins object under the Security folder on the SQL Server you wish to administer. Then, right click on the sa account and select Properties or simply double click on it. An new dialog box will open. Now, enter a new password in the Password field under the Authentication options.
All left is to click OK.

Rate this tutorial:                    
Networking, Programming and Graphics Tutorials - How to reset MSSQL sa user password with Enterprise Manager [1/1] - Networking, Programming and Graphics Tutorials

Need a specific tutorial? Do not hesitate and submit a request!
Related Tags: reset database user password sql enterprise manager  how to reset password database user in enterprise manager  reset user passwork SQL enterprise manager  reset the password in sql server enterprise manager  microsoft sql server reset password enterprise manager  reset MSSQL sa user password  sql 2000 enterprise manager server reset  enterprise manager 2000 user sa  enterprise manager change sa password  reset sa password sql 2000 enterprise