Friday, January 4, 2013

OM12 SP1 & SQL Server 2012

With OM12 SP1 SQL Server 2012 and SQL Server 2012 SP1 are supported! Which is nice. And yes, you can upgrade from SQL Server 2008 (R2 SP1) to SQL Server 2012 (SP1), more about it to be found here

However, upgrading your SQL Server 2008 (R2 SP1) instance hosting your OM12 SP1 databases to SQL Server 2012 (SP1) isn’t something to be taken too lightly nor something to be done without any preparation.

Don’t talk but SHOW it to me!
OK, here is some proof.

  1. Insert the installation media of SQL Server 2012 SP1 and click on Install Upgrade Advisor.
    image
    You’ll get some mumbo jumbo about a SQL Server 2012 component missing. Copy the url, download the proper installer, run it and install Upgrade Advisor.
  2. When installed run SQL Server 2012 Upgrade Advisor
    image
    > Next.
  3. > Detect. Now the installed SQL Server features will be detected:
    image
    > Next.
  4. Enter the required credentials and SQL Server instance name:
    image
    > Next.
  5. Select the database to analyze:
    image
    This SQL Server instance runs many databases, among the the OM12 databases.
    > Next.
  6. Enter the required credentials and Reporting Services instance name:
    image
    > Next.
  7. Enter the required credentials and Analysis Services instance name:
    image
  8. The summary of previous made choices is shown. Accept them or go back.
    image
    > Run.
  9. Now the analysis will be made which might take a while.

After some time the results are in:

  • Analyses Services is OK:
    image
    So this is no blocker.

  • Reporting Services isn’t OK:
    image
    Even worse, the upgrade is blocked!

    This was to be expected since OM12 (like SCOM and SCOM R2) adds it’s own security layer to the SSRS instance used for OM12.

  • SQL Server itself isn’t OK either:
    image

    And yes, it relates to the OM12 database:
    image
    And:
    image

So these issues have to be fixed BEFORE upgrading the SQL Server 2008 (R2 SP1) instance to SQL Server 2012 (SP1).

Recap
Upgrading the SQL Server 2008 (R2 SP1) instance hosting the OM12 SP1 databases to SQL Server 2012 (SP1) isn’t something to be done without a glitch. I’ll take a look into it whether these upgrade issues can be fixed. If so I’ll share them with you on my blog. Hopefully Microsoft will publish some TechNet articles as well about this topic.

Another approach could be installing a new SQL Server 2012 (SP1) instance and move your OM12 SP1 databases to that new instance. This way you don’t have to go through the upgrade process at all. But still, I would like to see some Microsoft TechNet articles on this particular DB move as well Smile.

2 comments:

SCREAMER said...

Hi,

do U know, if we successifully moved databases to SQL2012 or upgraded from 2008R2, can we change OM12 databases compatibility level to 2012?

Marnix Wolf said...

Hi Screamer.

I think so, but I am not sure. That's what I want to find out.

Cheers,
Marnix