Friday, April 29, 2011

Installing Management Reporter for GP 2010

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.

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

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.

  • 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"/>).