Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Trying to setup report...
Microsoft Dynamics GP (Archived)

Trying to setup reporting in GP correctly - SSRS

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello everyone, 

Recently I've went through the process of setting up Sql Reporting Services and I'm trying to get my Reporting tools setup in GP. I have the right Report Server URL and Report Manager URL entered, and I've told GP to deploy all reports for my companies. 

However, I went to add reports to my GP homepage, and they come up blank. When i go to View Report, I receive this error message. 

Screenshot-_2800_150_2900_.png
Any suggestions? 

For your info, I'm running SQL Server 2014, and my Report Server Service Account is a built-in "local system" account. When I try to enter reports from SSRS I receive a similar error message. See below...




*This post is locked for comments

  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Trying to setup reporting in GP correctly - SSRS

    Kimberly & Fritz,

    The issue with the error message "SQL Server Reporting Services setup information is not valid" comes actually from the SSRS security which has changed after SQL 2008R2... I ran into the same issue when upgrading to GP 2015 and trying to re-deploy the reports on a new installed SQL 2012 server... I never had issues before and done this several times. I use my domain account that is defined in the 'sysadmin' role on the SQL server security, but starting in SSRS 2012, that doesn't suffice anymore... You need to open the Report Manager screen and go into your site settings >> security and add yourself to the list of authorized users with 'System Administrator' role... That will solve the problem and let you deploy your reports.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trying to setup reporting in GP correctly - SSRS

    Sorry i wasn't much help!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trying to setup reporting in GP correctly - SSRS

    Hi Fritz,

    We actually received that same error first. I couldn't figure out how to fix it so I got in touch with Microsoft. Our technician told us to change to a local system, and went on to say we were having some kind of issue with a temporary profile. I wasn't in on the call so i didn't get the full scoop. They had a hard time solving the issue though, i know that!

  • Fritz Camille Profile Picture
    Fritz Camille 580 on at
    RE: Trying to setup reporting in GP correctly - SSRS

    Hi Kimberly,

    What are the dependencies that were missing? I'm trying do deploy SSRS Reports with GP 2015 using Reporting Services with SQL 2012. I receive the error: SQL Server Reporting Services setup information is not valid, when I try do deploy the services inside GP.

     

    thank you

     

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Trying to setup reporting in GP correctly - SSRS

    Never-mind! I spoke to Microsoft and we figured out what was happening. Somehow some dependencies were messed up.

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans