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