Unable to log into CCMWeb, CCC, or YSE. SQL errors in logs

Article ID: 51757 - Last Review: December 11, 2012


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


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


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.


CCM, all versions 


Posted Tuesday, December 11, 2012 by amontpetit