web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Business portal execut...
Microsoft Dynamics GP (Archived)

Business portal executive center access issue

(0) ShareShare
ReportReport
Posted on by Community Member

On a test evnironment of business portal I upon clicking on Executive center i get this message 'The permissions granted to user mydomain\TestUser' are insufficient for performing this operation. (rsAccessDenied)'

I have assinged the user as executive. Where to assign him further security to get Executive center up and running?

Regards,

*This post is locked for comments

I have the same question (0)
  • Rob Bernhardt Profile Picture
    Rob Bernhardt Microsoft Employee on at

    Zaheer,

    You must also give the user access to the SRS report.  This will include access to the report and also access to the data in the database.  How are your reports deployed?  Native or SharePoint Integrated?  How you give them access to the report will depend on how your SRS reports are deployed.  For data permissions, we recommend that you assign your user to a rpt_* sql role.

    Thanks

    Rob

  • Community Member Profile Picture
    Community Member on at

    I have deployed reports "Native" and there is green tick on SRS delplyed. In SQL security I have also added the user with server role

  • Rob Bernhardt Profile Picture
    Rob Bernhardt Microsoft Employee on at

    Since they are deployed in native mode, you'll need to go to Reports Manager > Folder Settings to give your user access.  

    One other thing to note is your environment.  Depending on how you've deployed BP and SRS, you may need to enable Kerberos authentication.  Could you describe your environment?  Specifically, how many machines and where do SQL, BP, and SRS live?

    Thanks

    Rob

  • Community Member Profile Picture
    Community Member on at

    I am in test phase SQL and BP are on the same server. I have GP 2010 and BP 5.1.  

  • Rob Bernhardt Profile Picture
    Rob Bernhardt Microsoft Employee on at

    In that case, you shouldn't have to worry about kerberos authentication.  Giving your user access to the SRS report and the data in SQL should resolve the issue.

  • Verified answer
    Derek Albaugh Profile Picture
    Derek Albaugh Microsoft Employee on at

    Hello Zaheer,

    To add to what Rob has provided so far, the users also must have the RPT_ database roles assigned to them under the DYNAMICS system database and/or company databases for Dynamics GP as needed.

    The RPT_ roles give users access to the data that the SQL SRS reports pull, whether through Dynamics GP, Business Portal or just running the reports through the Report Manager site.

    The RPT_AllUser role under DYNAMICS is required for all users, then the other RPT_roles are as needed. There is also a RPT_PowerUser role under the DYNAMICS and company databases if you want users to be able to access all data, similar to the PowerUser security role in the Dynamics GP application.

    Other than that, if the users have access to the SRS site and folders/report files as Rob mentioned, they should be fine, since you mentioned you have Business Portal, SQL, SQL Reporting Services all on the same test server.

    Thanks

  • Community Member Profile Picture
    Community Member on at

    Thanx Derek. It is very helpful detail. The issue has been solved. It is good learning experience.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans