Welcome Guest, Login


Quick Search

The CAREWare database must operate in multi-user mode in order for the cwbt and sa logins to have access to the cw_data database. The cw_data database can revert to single-user mode if an incorrect sa password is entered when restoring the database from a backup when following the instructions here.


To set the cw_data database back to multi-user mode from single-user mode:

  1. Stop the CAREWare business tier by following the instructions here.
  2. Connect to the CAREWare SQL Server database instance using SQL Server Authentication with the SA account.
  3. Expand Databases.
  4. Right click CW_Data.
  5. Click Properties.
  6. Click Options.
  7. Scroll to the bottom of the Other options list using the scroll bar on the right.
  8. Click Single_User for Restrict access.
  9. Select Multi_User.
  10. Click OK.

If there is an error when attempting to click properties, restart the CAREWare SQL Server Database Instance by following the instructions here and try the steps again. If there is still an error when accessing properties, try running this query to set CW_Data to multi-user mode:

  1. Right-click CW_Data.
  2. Click New Query.
  3. Type this query in the SQLQuery1 window.
  4. Click Execute.


Once the CW_Data database is no longer in single_user mode, start the business tier by following the instructions here.

Back to All CAREWare documentation

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.