Users of Master Data Services: If you have recently restored your MDS database, and MDS is no longer working as it should, this article should help get you back up and running.
Run each of these scripts on your MDS database. In these examples, our database is called "MDS_Sample."
1. Change the database owner
5. Enable CLR
You might also want to check to ensure that all of these users have the permission they are supposed to have: http://msdn.microsoft.com/en-us/library/ff486994.aspx
If you run into these issues or others and want to contribute to this article, please do!
Hi - this is really useful. Thanks. We are trying to automate our restore and sometime it says the database needs repairing. We go into the MDS Configuration Manager and do the repair, but is there a way of automating this ? i.e. a bit of SQL you can run or a script of some description ? Thanks.