Skip to content

System Center Configuration Manager 2012 and SQL Server 2012

06/27/2012

It is already the second implementation of SCCM 2012 using SQL Server 2012 and I noticed a problem in common in both cases, not allow using SQL Server Reporting Service as Reporting Point for SCCM 2012. All other roles and functions of SCCM 2012 with SQL Server 2012 is ok.

In the first implementation does not have much time to debug and try to find what it was, only myself in SCCM 2012 compatibility list at http://technet.microsoft.com/en-us/library/gg682077.aspx and installed the SQL Server 2008 R2.

Important: System Center 2012 SP1 release soon is include SQL Server 2012 support.

SYMPTOM

After you install SQL Server and run the prereqs of SCCM 2012 installation occurs successfully and configuration of the roles of SCCM is possible, except Reporting Point.

When you try to add a role Reporting Point in SCCM 2012 with the database and the SQL Server 2012 does not appear on the Reporting Services instance to be selected.

CAUSE

SQL Server Reporting Services (SRSS) 2012 is not compatible with the SCCM 2012, because WMI query wizard is used a filter clause to return the instances of SRSS using version (2005, 2008 and 2008R2) as parameter.

The same does not happen with the validator of the SCCM installation prerequisites in 2012 because it uses a query clause the inverted version of SQL Server that is used above, where is searched the above versions of SQL Server 2005 and not a fixed list of versions.

SOLUTION

Install SQL Server Reporting Services feature 2012, because the Service Pack 1 of System Center that will be released soon will support SQL Server 2012. On occasion export customized reports (rdp files) and remove the Reporting Point role, adding then SQL Server instance already in 2012.

During this period, install only the SQL Server Reporting Services feature of SQL Server 2008 R2. It is not necessary to install any feature of SQL Server 2008 R2, the database of SRSS 2008 R2 can use the SQL Server 2012 database to support SRSS 2008 R2.

Configure Reporting Services SQL Server 2008 by creating a database in SQL Server 2012 and back up the key, for when you leave the System Center 2012 SP1 is possible to use the same database reports, only configuring SQL Reporting Services Server 2012.

About these ads
4 Comments
  1. SQLDBA346 permalink

    I’m having problem SCCM 2012 with SQL 2012 reporting service. I was trying to add Reporing service point but could not able to add reporting instance there. Drop down option in add site system role wizard is not showing reporting instance there. SCCM 2012 still not supporting SSRS 2012 ?

    • My post is about this!!!!
      You need use SCCM 2012 SP1 to use SQL Server Reporting 2012.
      If your SCCM 2012 is not SP1 or R2 you need install SQL Server Reporting 2008 R2.

  2. SQLDBA346 permalink

    Thanks for quick response.

    Correction: we are using SCCM sp1. still having same problem.

Trackbacks & Pingbacks

  1. System Center 2012 with Windows 2012 and SQL Server 2012 « Marcelo Sincic [MVP]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: