In Part 1 of this multi-part post I detailed the Active Directory requirements for installing SCCM 2012 R2, in this post is the SQL Installation. In my lab I am going to be running this from an already existing SQL 2012 instance and I just needed to add the Reporting Services component to my installation, however the installation routine for adding the Reporting Services is somewhat similar for a new SQL installation and where it’s different I will let you know.
I know I said that Part 2 would contain the Windows OS requirements for the SCCM 2012 R2 installation but this has proven to be a bit longer than I expected.
SQL 2012 Adding SCCM 2012 Requirements – Reporting Services
As previously mentioned I will only be adding the Reporting Services component to an existing SQL 2012 installation, if you’re installing from scratch in to a lab environment it’s better to have the SQL installed locally for the SCCM instance, however because my current SQL server only has a single DB (VMware Update Manager) I decided to use that instead.
On your SQL Server run the SQL Server Installation Center wizard, click Installation
Now click New SQL Server stand-alone installation or add features to an existing installation
Browse to the installation media
As this passed all the rules click OK, otherwise inspect the report and try to resolve any issues.
As I have a connection to the Internet I am told about a product update, I am going to allow the update to be installed. Click Next
Clear up any issues if you have any, worth noting that I have a GPO setting that disables the domain firewall but I am still getting the error message.
If you do need to configure the Windows Firewall, have a look at this page for further assistance.
As this is an existing installation and all we are doing is adding to it, click the Add features button and choose your existing instance. Click Next
You can see here we don’t have Reporting Services installed, just click the box.
Here we can see that both Microsoft .Net Framework 3.5 and 4.0 are already installed, Microsoft Visual Studio 2010 Shell will be installed. Click Next
Resolve any issues that my appear here, then click Next
Check to make sure you have enough space, click Next
Enter the account name and password, in my case I am using a domain account rather than the local system account. Click Next
As this was just adding the Reporting Services I only had the Install only option, click Next
Check everything looks right and then click Install
Go away and make a cup of tea.
Success, the new feature has been installed.
Come back for Part 3 which will go through the Windows OS requirements for the SCCM 2012 R2 installation.