Friendly Reminder Before You Install ConfigMgr 2012 R2 CU1
Have you noticed that CU1 for ConfigMgr 2012 R2 has been released? If not head over here and read more about the Cumulative Update and what goodies it holds.
I’ve had contact with a customer that tried to install the update but ran into a warning during the installation. The warning was regarding the database upgrade. When they closed the installation wizard and started the console everything looked OK, but when we took a look in the log files we found that the upgrade had failed.
As you can see above we got:
Task ‘Perform Database Update; completed, state is ‘warning’ LastStatus: A SqlException occurred, Line Number: 159 Error 229 Message: The EXECUTE permission was denied on the object ‘fnIsPrimary’, database ‘CM_P01’, schema ‘dbo’.
When we took a look at this we found out that the account running the installation indeed was administrator in ConfigMgr – but NOT on the SQL server.
NOTICE!!! MAKE SURE TO HAVE A BACKUP BEFORE YOU TRY THIS !!!NOTICE
With some easy fixes to the update.sql file located in the %ProgramFiles%\Microsoft Configuration Manager\hotfix\KB2938441 folder we could re-run the script to upgrade the database.
If you need the fix, drop me an e-mail or comment below and I will share it with you after some further disclaimers