SSRS with SSAS – Message with no access to database in AX 2012

Continue reading

When running report connected with SSAS users get message “Either the user, <user>, does not have access to the <database> database, or the database does not exist.”‍

There can be multiple reasons – try one by one of possible solutions:

Step 1

Check if in Analysis Server exists database with name <database>. If not then there are 2 options:

Option 1

Try to redeploy and reprocess the cube using database name <database>.

Option 2

Change connection string:

  • Open Microsoft Dynamics AX Management Shell.
  • iRun command Get-AXReportDataSource -DataSourceName DynamicsAXOLAP| format-list
  • Copy the string from “ConnectionString”, change value in property “Initial catalog=” to your correct database name <database> and run the command Set-AXReportDataSource -ConnectionString “<ConnectionString>” -DataSourceName DynamicsAXOLAP
  • Redeploy reports to SSRS.

Step 2

Check if SSRS and SSAS services users and BI user have correct permissions to <database> database in Analysis Server.

Step 3

Try to redeploy and reprocess the cube.

Subscribe to our newsletter

Get Dynamics 365 news and insights

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.