I recently performed an installation of Reporting Services 2008 R2 in SharePoint Integrated mode on two servers. The SSRS integrated mode R2 version is supposed to have much improved performance over the previous version. I’m still in progress of benchmarking tests, so can’t comment yet, but there were some installation steps that I had to perform above and beyond the documented steps that I thought I’d post here as a reminder to myself – and anyone else that has a need. These steps were tested against the November CTP of R2 and might change when the Release Candidate comes out soon. I’ll post more complete instructions at that time and point out what changes, if anything.
You can install and configure the servers in any order, but integrated operations will not be available until the configuration steps are complete for both servers. For detailed information on the installation steps, see the Readme for the existing Reporting Services Add-in.
- Step 1: Install a SharePoint technology instance.
On RS01, I used the same installation media and used the Server Farm/Complete option. I ran the configuration wizard and selected the option “Connect to an existing server farm”. Then specify configuration database settings – point to RS01 and the database created when configuring SharePoint on SP01, provide the passphrase, and finish up by walking through the wizard using defaults. RS01 is joined to the SP01 farm.
- Step 2: Install SQL Server 2008 R2 November CTP Reporting Services and specify that the report server use SharePoint Integrated mode.
- Step 3: Configure Reporting Services.
- Step 4: Download the Reporting Services Add-in by clicking the rsSharePoint.msi link later on this page. To start the installation immediately, click Run. To install at a later time, click Save.
- Step 5: Install the Reporting Services Add-in and configure the report server on the SharePoint technology instance.
Here’s what I did to resolve – it just worked so no clue (nothing in event log) as to why it failed with normal installation:
- Open a command prompt.
- Change to the directory where the .msi file resides.
- Type msiexec /i SharePointRS.msi SKIPCA=1
- The installer opens. Just follow the normal flow, and it should finish successfully.
- Type cd %temp%
- Type rscustomaction /i
IMPORTANT – even if you have Admin rights on the server, you MUST open the command text prompt using Run As Administrator.
Type in the Report Server Web Service URL (as it appears in the Report Server Configuration Manager). Because I”m not using Kerberos in this environment, I set the authentication mode as Trusted Account. I put in the credentials for the admin on RS01, and clicked OK.
Here I ran into another problem. In the log file, I found the following message:
The request failed with HTTP status 401: Unauthorized
I knew this was some sort of authentication issue but it wasn’t immediately obvious where or how. From SP01, I could not connect to the server (http://RS01/reportserver) – I got the NT challenge prompt 3 times. Here’s what I did to fix:
I removed RSWindowsNegotiate from the RsReportServer.config file and then did stop/start on the SSRS service using the Reporting Services Configuration Manager. That left RSWindowsNTLM in the config file, and forced NTLM authentication for the report server and all was fine after that in terms of authentication.
Although I specified “activate feature in all existing site collections”, it didn’t happen. I had to manually activate the feature in my blank site but that worked fine. Then I successfully deployed reports and was able to view the reports. I’ll be analyzing performance in the coming weeks and will post my conclusions.