How to restore your MDS database on a different domain/server and fix the “Access Denied” error

One comment

This has happened to me a few times now and every single time I had to spend quite a bit of time sifting through the blogs looking for answers. So I finally decided to document it for myself here.

These are the steps:

  1. Go ahead and restore the MDS database on the server of your choice (running SQL Server database engine, obviously)
  2. Go to MDS Configuration manager, check if all the MDS settings are ok. It should give you fat check marks like this

     

     

  3. Click on Database configuration and connect to your MDS database… you may need to Upgrade your database if necessary
  4. Go to the Web configuration next and create the new web app if necessary
  5. At this point, if the user account who was the administrator is no longer accurate in the new environment, you will get “Access Denied” error when you try to go to the MDS Web Application, so don’t do it
  6. Connect to your MDS database from SMS, find the mdm. tblUser table, right click and Edit it.
  7. You will find a row that looks like this

     

     

  8. The reason you are getting Access Denied is because the SID and UserName values are no longer applicable, so you need to enter the SID and UserName for the new user who will be the administrator of the MDS
  9. Go to Command Prompt (as admin if necessary) and type wmic useraccount get name,sid
  10. This command will return a list of user accounts and SIDs, enter UserName as YourDomain\useraccount, and SID just as it shows up in the list from the wmic command and commit your changes to the table, restart your IIS and you should be all good to go…

1 comments on “How to restore your MDS database on a different domain/server and fix the “Access Denied” error”

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