System Center Configuration Manager 2012 and SQL Server 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.
Trackbacks & Pingbacks