Page History: What is the SA password and what does it do?
Compare Page Revisions
Page Revision: Mon, 25 Jul 2011 19:52
The SA password is created during the installation of CAREWare. It is a user defined password for the SQL Server database. Once a password is provided it cannot be changed unless the current password is known.
The System Administrator password is used for SQL Server database and you set it during a fresh install of the database. Once it is provided it cannot be changed unless you know the password. The installation is asking you to provide a new password. Write this password down and keep it in a safe place. You will not need the password to log in to CAREWare, only to manage the database.
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
Frequently Asked Questions