Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP2010 - upgraded to 1...
Microsoft Dynamics GP (Archived)

GP2010 - upgraded to 11.0.1935 and now SSRS reports don't work

(0) ShareShare
ReportReport
Posted on by Jennifer Wheeler

A couple fo days ago I installed the latest GP update that come out on 5/31/12 that takes GP to version 11.0.1935.  After installing it, my SSRS reports are not working.  I get either a 'Select permission was denied' or an 'Execute permission was denied'.  These all worked fine before so I had the permissions correct.  I did try and re-deploy the reports after the update but still no luck.  I have a SQL script that I used to run to set up the permissions way back when and I tried running that again but still no luck.  Anyone else run into this and know what the secret is to get the reports working again?

Thanks
Jennifer

*This post is locked for comments

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    Re: GP2010 - upgraded to 11.0.1935 and now SSRS reports don't work

    Are you still getting this error or has it been resolved?

    Let us know if you still need anything further.

    Thank you.

  • Verified answer
    Jennifer Wheeler Profile Picture
    Jennifer Wheeler on at
    Re: GP2010 - upgraded to 11.0.1935 and now SSRS reports don't work

    I figured out what the issue was.  For the setup of the data sources on the report server website I have it set to Connect using: - Credentials stored securely in the report server.  The user name that I use for that didn't have the DYNGRP role.  After I fixed that, everything is working again.  Not sure how this update took away that role from that user.

    Thanks

    Jennifer

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    Re: GP2010 - upgraded to 11.0.1935 and now SSRS reports don't work

    Jennifer,

    I wouldn't recommend assigning your users directly to DYNGRP.  This gives them access to the database objects, meaning they could directly query or alter tables (bypassing GP security).

    The rpt_* database roles were designed to give your users a more appropriate level of accessing for reporting.  They will give some select and execute permissions, but they won't give insert, delete, etc. permissions.

    I'd try assigning your users to one of these rpt_* roles.  I think this should help to resolve your issues.

    Thanks

    Rob

  • Jennifer Wheeler Profile Picture
    Jennifer Wheeler on at
    Re: GP2010 - upgraded to 11.0.1935 and now SSRS reports don't work

    I use the DYNGRP role to have access to the database objects and give everyone that role.  Like I said this all worked fine before upgrading and now it doesn't.  I double checked and DYNGRP still has access to everything.  So, I can't figure out why SRS thinks the permissions aren't correct when I see they are set correctly.

    Thanks

    Jennifer

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at
    Re: GP2010 - upgraded to 11.0.1935 and now SSRS reports don't work

    Jennifer,

    The recommended approach is to assign your users to predefinied roles.  The roles should have access to the underlying database objects.  I'm guessing either your users aren't assigned to roles or your roles no longer have access to the database objects.  That's where I'd suggest you start looking.

    Thanks

    Rob

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