Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Financial Reporting on premise permission issue

(0) ShareShare
ReportReport
Posted on by

Hi,

I got this error when try to open Financial Report designer for production and sand box environment on premise.

"Connection attempt failed. User does not have appropriate permissions to connect to the server. Contact your system administrator."

For One box development the report designer work fine but the problem exists in my production and sand box on premise. I look into user SID in FinancialReporting.Reporting.SecurityUser and AXDB.Userinfo are correct and user are assigned with security admin and system admin roles. I try to reset datamart by follow this link but no luck the problem still exists.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/reset-financial-reporting-datamart-after-restore?context=%2Fdynamics365%2Fcontext%2Ffinance#reset-the-financial-reporting-data-mart-for-dynamics-365-finance--operations-on-premises-through-sql-server-management-studio

no user can log in to Financial Reporting including user who deploy these 2 environment as well. Any advise?

  • RE: Financial Reporting on premise permission issue

    Hi Charlotte,

    MR is on on-premise environment and deployed by my user but my user also received this error when open the report designer too. any idea?

  • Suggested answer
    Charlotte X Profile Picture
    Charlotte X on at

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans