Welcome Guest, Login


Quick Search

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

jProg is a registered trademark of Jeff Murray's Programming Shop, Inc. All other products mentioned are registered trademarks or trademarks of their respective companies. Questions or problems regarding this web site should be directed to JeffMurray@jprog.com.

© 1998- Jeff Murray's Programming Shop, Inc. (jProg) , all rights reserved.