Fix: SQL Server Reporting issues with SharePoint
Situation: You have SQL Server Reporting installed and you have just installed SharePoint. You discover that your SQL Server Reporting stops working.
Piyush Mittal has documented his field experience.
Simple answer:
Using a dedicated application pool can help avoid conflict with existing Web applications.
Refer to this Microsoft article for more info.
If you install SharePoint Services after Reporting Services is already installed and configured, your Reporting Services installation will be unusable until you perform the following steps:
1. Start the Reporting Services Configuration tool.
STSADM.EXE -o addpath -url http://localhost/ReportServer -type exclusion
and
STSADM.EXE -o addpath -url http://localhost/Reports -type exclusion
By default, the Stsadm.exe file is located in C:\Program Files\Common Files\Microsoft Shared\Web server extensions\60\bin
2. Configure the Report Server virtual directories.
Check out this link to configure the directories.
Thanks Piyush.
