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
New course!

Programming in Dynamics 365 for Operations

19-23 June 2017
Wroclaw, Poland
In-depth Dynamics 365 for Operations training course is now available in Poland!
Read more →
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.