Tuesday, August 13, 2013

How to change the SQL sa password - For Security measure ( for SAs only)

1. How to change the SQL sa password in the SQL Server Enterprise Manager

To change the password on the 'sa' account from the graphical interfaces of MSSQL Server 7.0 and 2000 on both Windows NT 4.0 and 2000:
Quote:
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.

For More details SQL 2000 / 2005   -  Visit :  MRSupport
Note:
It is for the Use of System Administrators only for maintaining the Security 
source:sapost.blogspot.com

0 comments:

Related Posts Plugin for WordPress, Blogger...