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

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 

Keywords:



Rate this Article:
     

Add Your Comments


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

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