Moving database resulting in SSRS user account issues

When moving an AX database between system, especially when the primary accounts are different, you will often get an issue when running reports, reporting account x (from original system) does not have permission even though you have changed all the settings in AX to point to the correct environment and accounts.

The problem is caused because of old records contained in the table SYSSERVERSESSIONS. This table stores the AOS instances along with the user account for the AOS. When the database is moved to another system, a new entry (or entries) are created in this table, but the old ones are not removed. If the AOS account is different between environments this will cause a problem and you will need to ensure old entries are removed.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s