Page History: Receiving error: Login failed for user 'cwbt'
Compare Page Revisions
Page Revision: Mon, 28 Dec 2009 21:42
This error is caused by the database user 'cwbt' not being set as the owner of the database. There are several methods for resolving this error, which are listed below in order of ease ability.
# Go to the business tier directory (default location: C:\Program Files\CAREWare\RW CAREWare Business Tier)
# Open the CW Admin.exe utility
# Click on the Database Info tab
# Provide the database SA password
# Click the "Resolve" button in the lower rigth corner
If the "Resolve" button did not resolve the problem you can do the following:
# Click on the Server Settings tab
# Press "Stop Server"
# Highlight the DatabaseConnectionString and press "Edit"
# In the Setting field scroll to the right and locate "user=cwbt;password=cwbt100". If you changed the password for the user 'cwbt' during the installation of the database, then you will need to change it here.
# After correcting the password press 'Save'
# Click Start Server
OR
Use a SQL Manager such as Enterprise Manager, Craig's SQL Manager, or SQL Studio Manager Express to complete the following:
# Expand the CAREWare database
# Expand the CW_Data database
# Run the following query on the CW_Client table:
Exec sp_changedbowner 'cwbt'
# Restart the business tier service
The above procedures will set the CW_Data database owner to the user 'cwbt'. This is necessary for the business tier to communicate with the database. You may also need to run the query on each CW_Change_Log available in the CAREWare database.
Back to
Frequently Asked Questions