How do I modify the sa password for SQL?
Neil Pike
March 4, 1999
1 Min Read
A. The sa account is the standard admin account for SQL and has fullprivileges. To change the password perform the following:
Start the SQL Enterprise Manager
Expand the Servers and SQL 6.5 and Logins
Double click on sa
Select the password box. Delete the content and type your new password.
Click Modify
Enter the password again in the dialog. Click OK
Click Close
You may wish to enable Windows NT integration which means any member of theAdministrator's group will be logged in as sa automatically:
Start the SQL Enterprise Manager
Expand the Servers and SQL 6.5
Right click on the server and select configure
Click the "Security Options" tab
Select "Windows NT Integrated" from the Login Security Mode.
Click Apply Now then OK
About the Author
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
You May Also Like