Page History: What is the SA password and what does it do?
Compare Page Revisions
Page Revision: Thu, 27 Dec 2018 15:43
The person installing a new instance of SQL Server that uses mixed-mode authentication (as is required by CAREWare) sets the password for the SA (System Administrator) account. The SA account is used only for the management of SQL Server; it is not a CAREWare login.
If you lose the SA password the CAREWare Help Desk strongly suggests that you exhaust all attempts to recover the password before attempting to detach and reattach the database as outlined in the
System Administrator's Manual. If all attempts to retrieve the password are exhausted, refer to the System Administrator User Manual pages 22-23.
You can also change SA password within Management Studio using the following steps:
- Connect to the database instance using Windows User Authentication
- Expand the instance
- Expand Security
- Expand Logins
- Right click on SA and select Properties
- Delete the old password and enter the new one
- Delete the old confirm password and enter the new one
- Click OK
- Disconnect from the database instance
- Reconnect to the database instance using the SQL Server Authentication and user name SA with the new password
The steps above can also be used to change the password for user cwbt.
Back to the
Data TierBack to
Frequently Asked Questions