How to configure SSRS Report Subscriptions to use Gmail for GP

By Ryan McBee Prerequisites 1. You need to install the SMTP feature on your Windows Server instance.  In Server Manager go to the features section and click on Add Features. 2. Create and setup a Gmail account at http://www.gmail.com 3. Enable the Gmail account for POP3 in Gmail, you can follow the instructions on how to […]

Read More

SQL Reporting Services Error- Maximum request length exceeded

By Ryan McBee When trying to deploy a large Dynamics GP report to your SSRS server or creating a subscription for one of your canned GP SSRS reports, you may run into an error like this: Error 2 There was an exception running the extensions specified in the config file. —> Maximum request length exceeded. […]

Read More

SSRS GP 2010 R2 Reports and Business Analyzer Configuration

By Ryan McBee When upgrading to GP 2010 R2, you will want to make sure that you configure the Reporting Tools Setup window under Microsoft Dynamics GP>>Tools>>Setup>>System.  If you do not have this window configured, you will receive the message below which reads “Could not connect to configuration report.  Do you want to change your […]

Read More

Warm up Script for SQL 2008 Reporting Services

By Ryan McBee In SSRS 2005, after a period of inactivity (no calls to Reporting services), the first call to RS is very slow. This is more of an IIS issue than reporting services. The app pool generally winds down if there is no activity for a certain period of time. When the subsequent (first) […]

Read More