Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Reporting Tools Setup ...
Microsoft Dynamics GP (Archived)

Reporting Tools Setup on GP2010 R2 Problem

(0) ShareShare
ReportReport
Posted on by Sean Graham 315

Hi. I have a problem trying to deploy the SSRS reports through the Reporting Tools Setup in GP2010 R2 at a client site.

After filling in the Report Server and Report Manager URL and then clicking deploy I get the message "The SQL Server Reporting Services setup information is not valid".

The reports are deployed in Native Mode. I have successfully deployed on my own machine.

I can access the Report Manager and Report Server websites.

The SQL Server version is  : Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)   Apr 22 2011 19:23:43   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Anyone come across this problem?

Thanks,

Sean

 

 

 

*This post is locked for comments

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Reporting Tools Setup on GP2010 R2 Problem

    This is very sillly... I keep bumping into this issue and forget that starting with Windows server 2008 (and up, because of the UAC, even it's disabled) requires the GP client to be run in elevated privileges to deploy the SSRS reports... just makes no senses to me.

  • Tanya Henderson Profile Picture
    Tanya Henderson on at
    RE: Reporting Tools Setup on GP2010 R2 Problem

    I had success with running as administrator as well I was deploying on GP2013 and SQL 2012.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Reporting Tools Setup on GP2010 R2 Problem

    That would make sense. Until you go into SSRS as the domain admin and assign security you will not be able to deploy reports as anyone else. Glad it worked out.

  • Verified answer
    Sean Graham Profile Picture
    Sean Graham 315 on at
    Re: Reporting Tools Setup on GP2010 R2 Problem

    I found out what the problem was. I am deploying on Windows Server 2008. When I right clicked GP and chose "Run as Administrator", I was then able to deploy the reports.

    It's something I must remember to keep on doing on this server because I also noticed it disables other fuunctionality like Word Templates.

    Thanks for the help guys.

    Sean

  • Verified answer
    Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    Re: Reporting Tools Setup on GP2010 R2 Problem

    Sean,

    You could also try running Dynamics GP as an administrator.  Depending on your configuration, that may be necessary.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Reporting Tools Setup on GP2010 R2 Problem

    Sorry for my misunderstanding. Have you installed the SQL 2008 client onto your workstation? It sound like you are having trouble connecting to the SQL box and 2008 SQL Server requires the SQL 2008 client.

    You can download it from here:

    www.microsoft.com/.../details.aspx

    Go down not quite 3/4 of the way down the page.

  • Sean Graham Profile Picture
    Sean Graham 315 on at
    Re: Reporting Tools Setup on GP2010 R2 Problem

    Rob,

    It's a new environment. I'm just trying one company.

    Sorry, I have mislead you in my statement at the beginning.

    I was only testing on my own laptop the deploy method and it worked but this is not linked to trying to deploy at the client site i.e. not the same server etc.

    Thanks,

    Sean

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    Re: Reporting Tools Setup on GP2010 R2 Problem

    Sean,

    Is this a new or upgrade environment?  How many companies do you have deployed?  

    Looking back, I'm trying to understand your statement above.  You say that you've deployed with your machine, but now you can't with this SQL Server machine.  If you already deployed, why are you deploying again?

    Thanks

  • Sean Graham Profile Picture
    Sean Graham 315 on at
    Re: Reporting Tools Setup on GP2010 R2 Problem

    Accessing report manager is not the issue. I can access the url no problem.

    GP2010 R2 is currently only installed on the SQL server. So the server has the Dynamics databases and the ReportServer databases.

    On GP2010 R2, when I go into Tools > Setup > System > Reporting Tools Setup and try to deploy the SSRS reports I get the message "The SQL Server Reporting Services setup information is not valid".

    I am not trying to deploy reports through BIDS.

    The owner of the ReportServer databases is the domain administrator who I am logged in as.

    So I am not even at the stage yet of granting access to individual users for the reports. I need to deploy the reports first which is failing.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Reporting Tools Setup on GP2010 R2 Problem

    OK, just so I am clear on this. You go to a workstation and log in as the domain admin and it works. You log in as any other domain user and it does not work? I just reread the initial post, you are trying to deploy reports in BIDS correct? Who is the owner of the report server databases? You need to be logged in as that user in SSRS and then use that account to grant access to all your other users. Usually using EVERYONE to browse and then other users to deploy.

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans