I’m toying around with MDS 2016 CTP 2.3 in preparation of my SQLServerDays session about what is new for BI in SQL Server 2016. I uploaded the sample models into MDS and I opened up Master Data Manager in Internet Explorer to try out some of the new features. The Manager has received a make-over in the SQL 2016 preview, but two of the tiles were greyed out:
Quite annoying to say the least. Also, the version drop-down box doesn’t show any values. After a bit of Googling, a stumbled upon this MSDN thread, where it is explained it’s a bug which will be solved in the next release. If you’re an early adopter like me (and you want to actually do demo’s), you want this fixed now of course. Luckily there are two work arounds:
- Use an Application under the MDS website instead of a top level website. (this should correct some of the URLs)
- Edit the index.js file and correct the issue directly.
Since the first one is practically Chinese for me, I opted for option 2. In the index.js file (found in c:\Program Files\Microsoft SQL Server\130\Master Data Services\WebApplication\Scripts\) you need to locate /api/Models/ and change it to api/Models/.