Hello,
Many people are bored
of the
old black screen (command prompt). I like the way its done through a
Graphical Interface.
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.
|
Thats it !