AX2012 SSRS Error "You do not have sufficient authorisation to modify data in database"

Hi Friends,
Recently we got this error on running a SSRS report. For every report we were getting similar error. I was a system administrator so I was sure it should not be a permission issue but the error message was pointing towards permission and security settings. 

I also tried generating full CIL, restarting AOS, restarting SSRS , deleting *.auc files, cleared usage data but still got the same error.

I found technet article on similar error message here and verified that no such properties were changed in our system.

Then we gave a try by rebooting the machine hosting AOS and guess what the reports started working. 

So just rebooting the server helped us in this situation however the error message was pointing towards permission issue. In case you also face similar issue then please try this and also share any other resolutions to this error message which you find.

Thanks.

One Reply to “AX2012 SSRS Error "You do not have sufficient authorisation to modify data in database"”

  1. Unknown says:

    I check your blog very nice blog RF Post processing

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

A WordPress.com Website.
%d bloggers like this: