Navigation¶

• FAQ
• Feature Explorer
• All CAREWare documentation
• All Pages
• Create Account
  

Quick Search
»

Receiving error: Login failed for user 'cwbt'

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.

1. Go to the business tier directory (default location: C:\Program Files (x86)\CAREWare\RW CAREWare Business Tier)
2. Right click CW Admin
3. Click Run as Administrator
4. Click Database Info
5. Provide the database SA password
6. 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:

1. Connect to the CAREWare database instance
2. Expand Databases
3. Right click on CW_Data
4. Click New Query
5. Run the following query on the CW_Data database:
   
   Exec sp_changedbowner 'cwbt'
   
   
6. 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