Hi!

We use Windows Server 2008 R2 Enterprise SP1 with SQL Server 2012 SP2. We are trying to restore a production backup of the MDS database into our test environment of the exact same version and configuration. The database restore itself is working fine but after the restore we cannot any longer use the MDS Web application. Using the MDS Configuration Manager we where adviced to use "Repair the database" command. After this repair we instead getting the http://localhost/MDS/Unauthorized.aspx and Access Denied.  There is no $-signs appended to any users in the mdm.tblUser table. We have followed virtually any MDS related thread on the Internet regarding this issue with no luck.

If we revert the database to the old MDS database the MDS Webb is working again! This leads us to believe that this must be database related but how? Does MDS storing IP-numbers or other environmental information in the database? How can we resolve this issue?

Best Regards

Jan  

http://social.technet.microsoft.com/wiki/contents/articles/1766.troubleshoot-master-data-services-database-restore.aspx

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b192dc8b-55df-4622-9d4b-f668471c0f85/can-i-backup-mdm-database-and-restore-it-on-different-server?forum=sqlmds