Install Reporting Services 2008 R2 in Sharepoint Integrated mode via command line

In this article, we will discuss a few things to have you installing Reporting Services 2008 R2 with SharePoint 2010 in ‘SharePoint Integrated mode’ – not NATIVE mode using a config file for the SQL set up (Reporting Services is a SQL product) and also integrating Reporting Services with SharePoint (the Central Admin stuff).

Before we dig deeper, lets look at all the steps to set up Reporting Services with SharePoint in SharePoint Integrated Mode:
1. SQL Server Reporting Services  (SSRS) Installation and Configuration with SharePoint Integrated Mode as the chosen option.
2. SQL Server Reporting Services (SSRS) integration with SharePoint.
3. Create the Web Application and Site Collection in SharePoint.
4. Add Report Server Content Types in Site Collection
5. Create or upload a report in Site Collection

This article specifically assists you to perform Step 1 and step 2.

Step 1. SQL Server Reporting Services  (SSRS) Installation and Configuration with SharePoint Integrated Mode as the chosen option.

The actual step will look something like this. You run up a command prompt and navigate to the SQL server setup.exe file and then specify the configuration file (ensure the paths to the setup.exe and configRS.ini are correct).

setup.exe /CONFIGURATIONFILE="configRS.ini"

In my example above, I have named my configuration file as configRS.ini. You can name it to anything you want but remember to point to the exact ini file in the ‘configurationfile’ switch. The configuration file should look like this:

;SQLSERVER2008 Configuration File
[SQLSERVER2008]
ACTION="Install"
IAcceptSQLServerLicenseTerms="True"
FEATURES="SQL,RS,TOOLS"
INSTANCENAME=RSSQL01
SQLSVCACCOUNT="YOURDOMAIN\SQLSvcAccount"
AGTSVCACCOUNT="YOURDOMAIN\SQLSvcAccount" 
SQLSYSADMINACCOUNTS="YOURDOMAIN\SQLAdmins"
RSSVCACCOUNT="YOURDOMAIN\RSSvcAccount" 
RSSVCPASSWORD="password"
RSSVCSTARTUPTYPE="Automatic"
RSINSTALLMODE="DefaultSharePointMode"
INDICATEPROGRESS="True"
QUIETSIMPLE="True"
TCPENABLED="1"

Some notes on the above ini config:
FEATURE:
It doesnt work without the ‘SQL’ feature in it. You might want to try to remove it as you might already have a SQL instance running, but I have tested it and it defaults to NATIVE mode if the SQL feature isnt there.

INSTANCENAME:
The Reporting Services Instance Name.

SQLSVCACCOUNT:
The Service account for SQL Server service.

AGTSVCACCOUNT:

The account for the SQL Server Agent service.

SQLSYSADMINACCOUNTS:
These are the logins to be created as members with sysadmin role. I recommend you use an AD group and then add users to that group in AD.

RSSVCACCOUNT:
The service account for Reporting Services.

 

Step 2: SQL Server Reporting Services (SSRS) integration with SharePoint.

Run the following to integrate SSRS with SharePoint. The reporting services url contains ‘ReportServer_RSSQL01’, created by the previous step.

if ( ( [Microsoft.SharePoint.Administration.SPFarm]::Local.Services | where { $_.Name -eq "ReportingService" } ) -eq $null)
{
 $svcRS = New-Object Microsoft.ReportingServices.SharePoint.Common.SPRSServiceConfiguration("ReportingService", ( [Microsoft.SharePoint.Administration.SPFarm]::Local ) )
 $svcRS.RSServerUrl = [System.String]::Format("http://{0}/ReportServer_RSSQL01", [System.Environment]::MachineName)
 $svcRS.AuthenticationType = [Microsoft.ReportingServices.SharePoint.Common.RSAuthenticationType]::Windows
 $svcRS.Update()
}

Now that you have Reporting Services with SharePoint integrated mode configured and integrated with SharePoint, you would have to continue on to the other steps.

If you need automation in the remaining steps, let me know!

 

Leave a Reply

Your email address will not be published. Required fields are marked *