KB422251: “Project main DBRole should not be NULL or read-only” error message received when using Microsoft Excel 2003 as data source

SYMPTOM:
 
The following error message appears when running reports against Microsoft Excel 2003 in Strategy 9.0.1:
 

Project main DBRole should not be NULL or read-only

 
 
 
ACTION:
 
Please, follow the steps below to enable the writing on the desired Database Instance:
 

1. In Strategy Desktop, expand the Administration options, so expand the Configuration Managers options and click on Database Instances.
   
2. Right click on the desired Database Instance and select  VLDB Properties.
   
3. Expand the entry Tables, click on the option CREATE and INSERT support, so change its configuration to CREATE and INSERT statements are supported.   
   

 
NOTES:
 
KB422251