Confirm whether or not the Application Service is running correctly:
http://MRservername:MRport/SecurityService.svc
If you get any response, the service is running.
When installing the Management Reporter Server, ensure you use a specific account to run the service. DO NOT USE NETWORK SERVICE.
Whatever account you use to run the service MUST HAVE ACCESS TO THE SQL DATABASES: ManagementReporter, Dynamics, all CompanyDB's
Most of these issues can be solved if you use a specific domain account to run SQL. Use the same account to run MR.
Friday, April 29, 2011
Thursday, April 28, 2011
Installing SRS Reports for GP10
Error: retrieving the com class factory for component with clsid
http://community.dynamics.com/product/gp/f/32/p/33662/95991.aspx
Need to download 64-bit components for GP, then run GP SRS Wizard
http://community.dynamics.com/product/gp/f/32/p/33662/95991.aspx
Need to download 64-bit components for GP, then run GP SRS Wizard
Tuesday, April 26, 2011
How to Deploy SSRS Reports for Dynamics GP 2010 +
Before beginning, make sure you have entered the registration keys for your Dynamics GP. If you do not, the modules will not be detected, and no reports will be deployed.
1) Run the setup from the Dynamics GP installation disk
2) Install SQL Server Reporting Services Wizard
3) Find the wizard in your Program Files, run the wizard
4) Enter server, username, and password
5) Select company, and all reports
6) Enter report server URL http:\\localhost\reportserver
7) Click Finish
Right click on GP and click run as>administrator
Log in as sa
1) Go to Tools>Setup>System>Reporting Tools setup
2) Enter Report Server URL http://localhost/ReportServer/reportservice2005.asmx
(For 2013+ the address is http://localhost/ReportServer/)
3) Report Manager URL http://localhost/Reports/Pages/Folder.aspx
(For 2013+ the address is http://localhost/Reports/)
(replace localhost with your report server name)
4) Click OK
And you're done.
SRS Reports should now be deployed to your SRS manager, and they should be visible within GP's report lists.
Also check out
http://support.microsoft.com/kb/954242
It has a list of common issues and solutions
Related errors:
You continue to get the "the sql server reporting services information is not valid" even though you are using the correct address.
1) Run the setup from the Dynamics GP installation disk
2) Install SQL Server Reporting Services Wizard
3) Find the wizard in your Program Files, run the wizard
4) Enter server, username, and password
5) Select company, and all reports
6) Enter report server URL http:\\localhost\reportserver
7) Click Finish
Right click on GP and click run as>administrator
Log in as sa
1) Go to Tools>Setup>System>Reporting Tools setup
2) Enter Report Server URL http://localhost/ReportServer/reportservice2005.asmx
(For 2013+ the address is http://localhost/ReportServer/)
3) Report Manager URL http://localhost/Reports/Pages/Folder.aspx
(For 2013+ the address is http://localhost/Reports/)
(replace localhost with your report server name)
4) Click OK
And you're done.
SRS Reports should now be deployed to your SRS manager, and they should be visible within GP's report lists.
Also check out
http://support.microsoft.com/kb/954242
It has a list of common issues and solutions
Related errors:
You continue to get the "the sql server reporting services information is not valid" even though you are using the correct address.
- Right click on GP and click run as>administrator
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"/>).
Subscribe to:
Posts (Atom)