Database Single-User Mode

Modified on Mon, 20 Mar 2017 14:02 by Kevin Ricciardo — Categorized as: Uncategorized

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.

Image

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.
    ALTER DATABASE CW_Data.
    SET MULTI_USER.
  4. Click Execute.

Image

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