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. |
2.How to change the SQL sa password from a command prompt
Start a command prompt by typing Start – Run – cmd
Enter the following commands, pressing Enter after each line
OSQL -S yourservername -E
1> EXEC sp_password NULL, ‘yourpassword’, ‘sa’
2> GO
1> EXEC sp_password NULL, ‘yourpassword’, ‘sa’
2> GO
Where yourservername is the name of your server and yourpassword is the new sa account password. Type exittwice to return to the server desktop.
This works in SQL 2005, I don’t have access to other versions so I can’t say if it will or won’t work other versions of SQL.
Login into SQL Server using Windows Authentication.
In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.
Change SA password, and confirm it. Click OK.
Make sure to restart the SQL Server and all its services and test new password by log into system using SA login and new password.
Note:
It is for the Use of System Administrators only for maintaining the Security
It is for the Use of System Administrators only for maintaining the Security
0 comments: