Receiving error: Login failed for user 'cwbt'
Modified on Fri, 28 Dec 2018 11:49 by Kevin Ricciardo — Categorized as: FAQ
The error "login failed for user cwbt" happens when the database user 'cwbt' is not set as the owner of the CAREWare database. There are several methods for resolving this error; they are listed below in order of simplicity.
Click
here
to see the entire error message.
Go to the business tier directory (default location: C:\Program Files (x86)\CAREWare\RW CAREWare Business Tier)
Right click
CW Admin
Click
Run as Administrator
Click
Database Info
Provide the database
SA
password
Click
Resolve
If
Resolve
is not there or does not resolve the issue follow these steps
here
.
If the issue persists, use SQL Server Management Studio to complete the following:
Connect to the CAREWare database instance
Expand Databases
Right click on CW_Data
Click New Query
Run the following query on the CW_Data database:
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 the CW_Attachment and CW_PDI databases.
Back to
Errors
Back to
Frequently Asked Questions