-
Title
SQL processing fail due to database compatibility level -
Description
The SQL Processing wizard failed with the following error in the log file:
"Servername Error -2147218684 The master database has a Compatibility Level lower than required and cannot be processed." -
Cause
This is due to SQL Processing Wizard will not process 2000 Database in 2005 SQL server.
-
Resolution
WORKAROUND:
Raise the SQL Compatibility to 90.
STATUS:
Enhancement Request ST52640 had been submitted to Development for consideration in a future release of Migration Manager for AD. -
Defect ID
ST52640 -
Additional Information
For more information regarding SQL compatibility, please refer to SOL18731, Does the Foglight Cartridge for SQL Server require compatibility for the work database to be set to 80? There are no hotfix for ST52640 in QMM 8.8 and 8.9 on March 2013. May not be implemented at all for SQL server 2005. - https://support.quest.com/SUPPORT/index?page=solution&id=SOL18731