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.

cm install in azure

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.

Solution

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 :)

/Tim

zv7qrnb

About The Author

Tim Nilimaa is a consultant with Lumagate in Sweden. He has been working with Configuration Manager for 8 years. His knowledge has been selected as a speaker at many events among them Microsoft Management Summit.

3 Comments

  1. Dan Allevato says:

    Tim,
    Can you send me the fix for the SQL db not updating? My account did not have access to the DB and thus it didn’t have access to the SQL DB. Forgot to login with the configmgr account. RATZ! THANKS! dAN.

    Reply
    • Tim Nilimaa says:

      Dan Allevato,
      Basically you should be able to run the script as it is stated on http://go.microsoft.com/fwlink/?LinkID=234841 that the CU1 setup actually refers to.

      Reply
      • Tim Nilimaa says:

        …if that doesn’t work, drop me an email using my first name at my lastname .se and I’ll send you what I did to get it working :)

        Reply

Leave A Reply