How do I modify the sa password for SQL?

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo

A. The sa account is the standard admin account for SQL and has fullprivileges. To change the password perform the following:

  1. Start the SQL Enterprise Manager

  2. Expand the Servers and SQL 6.5 and Logins

  3. Double click on sa

  4. Select the password box. Delete the content and type your new password.

  5. Click Modify

  6. Enter the password again in the dialog. Click OK

  7. 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:

  1. Start the SQL Enterprise Manager

  2. Expand the Servers and SQL 6.5

  3. Right click on the server and select configure

  4. Click the "Security Options" tab

  5. Select "Windows NT Integrated" from the Login Security Mode.

  6. Click Apply Now then OK

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