I am trying to set up two instances of SSRS 2008, one in Native mode and the other in SharePoint integrated mode. I tried to make the default instance Native and then created a second instance in SharePoint Integrated mode. However, there seems to be a problem with the new Reporting Services Add-in for SharePoint. (Well for me anyway. I’d be interested if others have had the same problem) After installation no Report Services Integration items showed up in SharePoint Central Administration, although the new content types did appear in my MOSS site. So I was unable to tell SharePoint which instance I wanted it to use.
Also, the add-in installation seemed to trash all my Site Collection Administration settings in all my WSS sites. Very bizarre! They came back on any site collections that I deleted and recreated.
So anyway I tried a couple of different things to see if I could get it working. I switched the instances around and made the default instance SharePoint Integrated mode, and tried reinstalling the Add-In. This still didn’t seem to solve the problem.
The next thing I tried was to uninstall the RTM Add-in and install the RC0 version of the Add-In. (Well the Report Builder 2.0 RC0 seemed to be working fine, so I thought, what the heck I’ll try it)
Well, the Report Services Integration items showed up right away, allowing me to configure the thing! Now it’s all working fine with SSRS RTM, but SQL Server 2008 Reporting Services Add-in for SharePoint RC0. Not entirely sure why! But at least it’s up and running 🙂