MDS database upgrade failed, ‘user does not have access to the application’ (db version 11.2.0.5)

Yesterday a colleague upgraded our reporting server (SQL Server 2012 SP1 CU6) to CU7 (build: 11.0.5623), which should be stable since it is out for like a month now.
(More info aboud builds? Check out: http://sqlserverbuilds.blogspot.nl/)

As always MDS requires a database upgrade (because we’ve upgraded the ‘client‘ to a new version, as in ‘the SQL Server instance‘):

MDS-database-requires-upgrade-11-2-0-5-GUI


 


 


 

Sure, let’s do that.

So I RPD-ed into our reporting server. Right-click on the ‘Master Data Services Configuration Manager‘-icon in the start-menu and clicked ‘Run as Administator‘ (important one!).
And indeed, it does require an upgrade 🙂

MDS-client-version-incompatible-with-database-error-11-2-0-5-GUI


 


 


 


 


 

Next step is to select the correct database and hit the ‘Upgrade‘-button….but…it threw me an exception:

MDS-upgrade-wizard-exception-error-user-does-not-have-access


 

Hit ‘OK‘ and ‘Cancel‘, notice that the database version jumped to ‘11.2.0.6‘?:

MDS-database-version-11-2-0-6-GUI


 


 


 

What I found was that whatever you try next, the wizard keeps throwing the same exception over and over again when you restore the MDS database and try again.

The thing is that, after a while I just ignored the exception and went to the MDS interface with IE and somehow things are working properly.

 

Conclusion:
So, when you’re upgrading the MDS database from ‘11.2.0.5‘ to ‘11.2.0.6‘ ignore the following exception from the wizard:
‘…The user does not have access to the application…’

Because the user does have access and the script did run correctly 🙂


 


 

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