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.

More articles
Explore our blog

What can we do for you?

We'd love to hear about your project. Our team will get back to you within two working days.

Thank you for inquiry, we’ve passed it to our sales department, our representative will reach you back in his earliest convenience.

Oops! Something went wrong while submitting the form.
.

Dziękujemy za zapytanie, przekazaliśmy je do naszego działu sprzedaży. Nasz przedstawiciel skontaktuje się z Państwem w najbliższym możliwym terminie.

Ups! Coś poszło nie tak podczas przesyłania formularza.