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

Expand / Collapse

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 


Rate this Article:

Add Your Comments

Name: *
Email Address:
Web Address:
Verification Code:

Last Modified:Tuesday, December 11, 2012
Last Modified By: amontpetit
Type: FIX
Article not rated yet.
Article has been viewed 4,451 times.