A. The sa account is the standard admin account for SQL and has full privileges. 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 the Administrator'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