PROBLEM

You are unable to log into any prairieFyre applications including CCMWeb, CCC, and YSE. 

SYMPTOMS

When you connect to the database using SQL Management Studio you find that the CCMData database is set to Read-Only.

RESOLUTION

This is a SQL configuration issue, and as such is best effort support from prairieFyre.  We recommend you try to manually remove the read-only attribute by doing the following:

1. Open SQL Management Studio, and log in as a SQL administrator.
2. Click the New Query button at the top left.
3. Type in RESTORE DATABASE <CCMData> WITH RECOVERY and then click the '! Execute' button at the top.  Repeat for CCMStatisticalData if it is also shown as read-only.

If this does not resolve your issue, please consult Microsoft support for more information.

APPLIES TO

CCM, all versions