FIM 2010 R2 SP1: Reporting and Auditing Services with System Centre Service Manager 2010 SP1 "The SSRS Web Services URL is not valid." and SQL Reporting Service "The report server installation is not initialized (rsReportServerNotActivated)

I have been building out a full Forefront Identity Manager 2010 R2 SP1 solution including the optional component of Reporting and Auditing Services. The components of Reporting and Auditing Services for FIM 2010 R2 SP1 are System Centre Service Manager 2010 (SCSM 2010) and SQL Server Reporting Services. I was in the middle of installing the System Centre Service Manager Data warehouse component of SCSM 2010 and the installation was stopped when I was asked to "Configure the Reporting Server for the Data Warehouse", I pointed to the SQL Reporting Service Server and it returned the error "The SSRS Web Services URL is not valid." this stopped me from continuing.

 

 

For testing I tried to open one of the preconfigure Reporting Services websites, when I did this the website was not operational with the error SQL Reporting Service "The report server installation is not initialized (rsReportServerNotActivated).

 

The solution in this case was to click on the Encryption Keys page and under Delete Encryption Content us the delete key to remove the encryption files.

 

 

You will be asked to confirm you want to delete the encrypted content.

 

After doing that I returned to the website and did a refresh the website was then functioning. When I returned to the Server Manager interface and refreshed that, the error was also resolved and I could continue with the install.

Installing and Configuring the Reporting Services (SRS) Point for ConfigMgr 2012 R2 (SCCM)

You should begin with installing the Reporting Services - Native instance feature from the SQL 2012 media.

 

You will be prompted to name the SQL Instance I named mine SRS. Click Next.

 

When Reporting Services installs successfully, click Close.

 

You must now configure Reporting Services before it is integrated with SCCM 2012 R2. Click the Reporting Services Configuration Manager icon from Start.

 

Click on the Service Account tab, and select Use another account: and input an Administrative domain account, and click Apply.

 

Skip over Web Services URL for now, and click Database.  Click on the Change Database button.

 

You will then follow through the wizard to provision a new database instance.

 

Also click Change Credentials from the Database tab, and ensure it is using an Administrative domain account. Click Apply. Now go back to the Web Service URL, you do not have to change any configurations here you must simply click Apply and this will push the wizard to provision and configure the IIS virtual directories to support the Reporting Server.

 

Now launch the ConfigMgr console and click Adminstration, expand Site and then Server and Site System Roles. Right click on your Primary Site Server and select Add Site System Roles.

 

Tick Reporting Services Point and click Next to continue.

 

Review the configurations and set the Reporting Services Username to an Administrative domain account. Click Next.

 

Reporting Services is now installed and configured.