SSRS2008 Sharepoint Integrated Mode fix

Here are some notes on SSRS2008 in an integrated mode:

1. When integrating Reporting Services you will need to install the rsSharePoint.msi in order to set the configuration properties in SharePoint and use the Report Viewer.

2. Before you install it, go into Component Services and select DCom.

a. Right click IS_WamReg → Properties.

b. Open the Security tab and under custom security, add your SharePoint and Reporting Services service accounts giving them launch and activate permissions.

c. If necessary, you can also give them remote launch and remote activate permissions.

d. Reset IIS ( open command window and type iisreset )

3. Next install rsSharePoint.msi using the following command: msiexec /I yourfilepath\rsSharePoint.msi SKIPCA=1 (that is a capitol letter “i” after the “/”).

4. Switch to your %temp% directory and run the following command: rscustomaction.exe /I (again a capitol letter “i”).

Reporting Services 2008 Add-in to Sharepoint Problem

So you do the install found here. And you go to Sharepoint Central Admin and in Application Management, the Reporting Services section is NOT there, right? sound familiar. Well, I think it has something to do with rights, and site collection administrators, etc…but luckily there is an easy albeit hard to find fix.

In the Sharepoint Central Admin site, go to Site Actions (the far right corner). Select Site Settings and under Site Collection Administration, select Site Collection Features. You will see a list of collection features, including, Report Server Integration Feature. Click on Activate. Then on the Application Management tab of Central Admin, the Reporting Services section should be lit up and ready to configure.  

Configuring SSRS for MOSS Integration

Same handy dandy links.

How to integrate SharePoint Server 2007 or Windows SharePoint Services 3.0 with SQL Server 2005 Reporting Services by using the Reporting Services Add-in

· Tom Wisnowski’s “Configuring Kerberos for SharePoint” document (corpnet)

· Joel Oleson’s Kerberos Authentication and SharePoint Key Resources

· Information Integration: SSRS and MOSS 2007

· SSRS and MOSS 2007

· Configuring Kerberos for SharePoint 2007: Part 1 – Base Configuration for SharePoint

· Use Kerberos to Secure MOSS 2007

· Essential Tips On Kerberos for SharePoint Deployers

· Configuring Kerberos for SharePoint

· Configuring Constrained Delegation for Kerberos (IIS 6.0)

· Keith Brown’s (free) online book (The .NET Developer’s Guide to Windows Security)

o Item 59: What is Kerberos?

o Item 60: What is a service principal name SPN?

o Item 61: How to use service principal names

o Item 62: What is delegation?

Annoying publish to sharepoint thing

In the all up BI VPC there is a workflow when you publish a PPS dashboard to MOSS. Seen this?

Well…what you do is go to the dashboard aspx page in the doc library. click on the down arrow (edit), and "publish a major version". Then Approve it.

Adding an SSRS report to PPS M&A in Sharepoint Integrated Mode

ReportServer URL should point to the Report Server Web Service URL, which is something like http://servername:port/Reportserver

Report URL should point to the complete path to the rdl….http://sharepointsite/reports/reportlibrary/report.rdl

 

The docs are here but they aren’t so descriptive:

http://office.microsoft.com/en-us/performancepoint/FX102380591033.aspx

 

 

Reporting Services in Sharepoint integrated mode

The trick here is to create a new Report database and change the server mode and check the ‘Create the report server database in Sharepoint Integrated Mode’. That needs to be done first before installing the Add-in.

 

The order of install is

 

1-      Install SP2

2-      Run the Reporting Services Configuration Manager

3-      Install the Reporting Services Add-in

4-   Configure the Reporting Services integration from within SharePoint 

Sharepoint Integration with Reporting Services

SP2 of SQL Server has an interested feature that integrates Reporting Services into Sharepoint. Essentially replacing Report Manager. Its very cool. However it requires you to change a few project properties in BIDS in order to deploy your reports.

In the project menu go to properties and change under Deployment:

 

TargetDataSourceFolder = http://<servername>/Reports/Data%20Connections

TargetReportFolder = http://<servername>/Reports/ReportsLibrary

TargetServerURL = http://<servername>/Reports/ReportsLibrary

 

This is specific to my system but I hope you get the point. They all have to be URLs.