February 23, 2012

How to change the SQL sa password

How to change the SQL sa password in the SQL Server Enterprises Manager
To change the password on the "sa"accounts from the graphical interfaces of MSSQL server 7.0 and 2000 on the window NT 4.0 and 2000:
1. Open the "SQL Server Enterprise Manager". This is usually under "Start"-->"Programs"-->"Microsoft SQL Server".

2. 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".

3. Now, enter a new password in the "Password" field under the "Authentication" options.

Reactions:

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...
Related Posts Plugin for WordPress, Blogger...