Notifications
Announcements
No record found.
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?
Hi Dhanate,
Please refer to this post:
(+) Connection attempt failed. User does not have appropriate permissions to connect to the server. Contact your system administrator. - Microsoft Dynamics AX Community
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?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
