BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« SSRS 2008 Pie Chart Formatting | Main | SQL Server 2008 Reporting Services Integration with SharePoint 2010 »

January 27, 2010

SQL Server 2008 Reporting Services Integration with SharePoint 2010

I have been working with a Virtual Machine running SharePoint 2010. It has SQL Server 2008 Enterprise Edition but it did not have SSRS installed. I therefore downloaded the 64-Bit version of SQL Server Enterprise to install the extras.

I went through the process and when I saw some options disabled I figured something was wrong:



The SharePoint options were disabled. I couldn't select Native or Integrated mode here. I realized that it was looking for MOSS 2007.

I therefore realized that SQL Server 2008 R2 probably has the SharePoint 2010 awareness. I immediately downloaded the SQL Server 2008 R2 Enterprise Evaluation and installed it on the VM. This time I was able to configure Reporting Services properly:







After downloading and running through the installation ofSQL Server 2008 R2, I realized that the process for installing Reporting Services is essentially the same as before (with SQL Server 2008 making it a little easier than SQL Server 2005). This means that you still need to install the SharePoint Add-in as well.

So what you need are both parts:

SQL Server 2008 R2 November CTP

http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx
(I used the download from MSDN but it is publicly available using the above link)

SQL Server 2008 R2 RS Addin for SharePoint

http://www.microsoft.com/downloads/details.aspx?FamilyID=16bb10f9-3acc-4551-bacc-bdd266da1d45amp;displaylang=en

After you install the Add-In for Sharepoint, new options appear in Central Admin (just like in MOSS 2007):



Clicking on the Reporting Services Integration allows you to complete the integration process:



But it appears now can specify which site collections to deploy and activate the features. I had a few other site collections on the VM but under the /sites/ managed path. I am therefore thinking that it is really asking you to select the Root Site Collection (so if I had a another web application with a site collection, that would be shown in the selection box as well).

After successfully integrating, a Reporting Services option appears under the site collection site settings:




That's about as far as I have gotten so far. I did, however, wanted to check BIDS to see what Data Sources were available. I had ahunch that a SharePoint list would now be an integrated option (instead of having to create an extension as I have done before in SQL 2005). I was right:



I am pretty sure that wasn't in there before I installed R2.

So overall in SharePoint 2010 it's the same process to install Reporting Services in Integrated Mode but with the SQL Server 2008 R2 installs.



Posted by Steve Mann at January 27, 2010 3:56 PM

Comments

Post a comment




Remember Me?