KB41857: “Failed to Start Service Error Code: -1 Return Code: 0x80041441” error message is encountered when trying to start the Intelligence Server in MicroStrategy 10.x

SYMPTOM:
 
When starting the Intelligence Server, the following error is encountered:
 
 

'Failed to Start service Error Code: -1 Error Message: StartUpManager::StartUpManager(): LoadServerDef failed. Return Code: 0x80041441'

 
 

 
 
The following error is also logged to the DSSErrors.log:
 
 

2012-09-04 16:26:30.447-06:00 [HOST:SERVER][PID:1234][THR:4321][Database Classes][Error] Execute Query failed. 

Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42000:229: on HSTMT] [Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'DSSMDSYSPROP', database 'DATABASE_NAME', schema 'DBO'. Connection String: DSN=METADATA_DB;DESCRIPTION=METADATA_DB;UID=Strategy;APP=Strategy 9.0 ® Common Files;WSID=MSTR;DATABASE=DATABASE_NAME;. SQL Statement: SELECT NAME, PROP_VAL FROM DSSMDSYSPROP.

 
 
CAUSE:
The database user that is used to connect to the metadata does not have the required permissions against the database. As a result, Strategy is unable to execute any queries on this database.
 
 
ACTION:
Before re-attempting to start the Intelligence Server, the user should request the Database Administrator to grant the required permissions on the database user that is used to connect to the metadata.