SQL Server = SQL
Sharepoint Server = Sharepoint
Reporting Services Server = RS
GP Server = GP
We need to install Reporting Services in Sharepoint Integrated mode so that the reports are displayed through sharepoint, but each software is installed in a different server.
Solution:
Ensure that you can access Reporting Services Manager from Sharepoint Server
Create a library to store the reports. I created GPReports as my empty library.
Install Dynamics GP Shared components and GP Client on Sharepoint, and deploy reports from there
(you can uninstall after the deploy)
Sharepoint Site = http:\\Sharepoint\
Library = GPReports
Deploy.
You will get the "The deployment has exceeded the maximum request length allowed by the target server" error
Go to
c:\Program Files\Microsoft SQL Server\(SRS Instance)\Reporting Services\ReportServer\web.config
Find
<httpRuntime executionTimeout="9000" />
Change it to (<httpRuntime executionTimeout="9000" maxRequestLength="20960"/>).
Also check out
http://support.microsoft.com/kb/954242
It has a list of common issues and solutions regarding SSRS
Also check out
http://support.microsoft.com/kb/954242
It has a list of common issues and solutions regarding SSRS
No comments:
Post a Comment