Please pay attention to the following guidelines:
- Uninstall the SCOM SP1 agent from the SQL server before upgrading your RMS
- To speed up the upgrade process, run the following query using SQL Management Studio:
- Make sure the OperationsManager DB is configure to accept updates using the following command:
exec sp_configure ‘allow updates’, 0
RECONFIGURE WITH OVERRIDE
- Note that if your database cannot accept updates you will get the following error during installation – ?Error 25154.Failed to execute SQL script. Error Code: ?2147217900?
That’s the main caveats we came across.