Tag Archives

3 Articles

Master Data Services 2014 Add-in for Excel published

Just a bit over a week ago a new version of the Master Data Services Add-in for Excel was released. It is the 2014 release, which will also work for SQL Server 2012. Main benefit is up to 4x performance improvement without any server configuration changes. If you need extra performance you can get 2x extra by enabling Dynamic Content Compression in IIS on your MDS server.

Here is the download page: http://www.microsoft.com/en-us/download/details.aspx?id=42298.

Installing Master Data Services add-in for Excel 2013

I recently picked up my new laptop, which of course runs Office 2013 and Windows 8.
When you try to install the Master Data Services add-in for SQL 2012 you may run into a warning that says you need Office 2010.

There is an easy fix: just install the Master Data Services add-in for SQL 2012 SP1 (get it here: http://www.microsoft.com/en-us/download/details.aspx?id=35581 . Be sure to pick 32 / 64 bit to match your Office version.

Oh and of course you will have to get the other pre-req as well: Visual Studio 2010 Tools for Office runtime (find it here: http://www.microsoft.com/en-my/download/details.aspx?id=35594).

See http://support.microsoft.com/kb/2774422 for more information.

MDS / DQS integration on a domain controller

Normally I would never advice you installing anything on a domain controller, let alone SQL, MDS and DQS. However if you have BI demo machine you will probably have all this (and more) running on the same box. At least I do J

If you do you will probably get this error message when you try to enable the DQS integration from Master Data Services Configuration Manager after you successfully installed DQS and MDS.

When clicking the button ‘Enable integration with Data Quality Services’ an error will pop-up:

Here is where it gets a bit confusing. If you read the error message closely, it seems that MDS is looking for a local account on your machine instead of a domain account. However, with it being a domain controller, you cannot create local accounts…

To make this work you need to do the following:

  1. Add a Windows User Login into SQL Server for [YourDomain]\MDS_ServiceAccounts.


  2. Then run the following query against your DQS_MAIN database, which creates a user on the DQS_MAIN database which maps to the login you just created and adds the user to the DQS_Administrator role. Of course you can also do this using the UI. Make sure to enter your DOMAIN in the query below before executing.

    use [DQS_MAIN]
    CREATE USER [MDS_ServiceAccounts] FOR LOGIN [YourDomain\MDS_ServiceAccounts]
    exec sp_addrolemember @rolename=N’dqs_administrator’,@membername=N’MDS_ServiceAccounts’
  3. When done go back to the Master Data Services configuration manager and hit the button again. Now it should come back with:

Victory ! J


%d bloggers like this: