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

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

Tutorial
Published on
Jun 30, 2016

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.

Share it
Written by
Michal Szemplinski

Microsoft Dynamics developer from July 2008. Comes from Tychy in Poland. Graduated at Silesian University of Technology as Computer Science Master.