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:
- Add a Windows User Login into SQL Server for [YourDomain]\MDS_ServiceAccounts.
- 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]
GO
IF NOT EXISTS (SELECT * FROM SYS.SYSUSERS WHERE NAME = ‘MDS_ServiceAccounts’)
CREATE USER [MDS_ServiceAccounts] FOR LOGIN [YourDomain\MDS_ServiceAccounts]
exec sp_addrolemember @rolename=N’dqs_administrator’,@membername=N’MDS_ServiceAccounts’ - When done go back to the Master Data Services configuration manager and hit the button again. Now it should come back with:
Victory ! J
Share this:
- Click to share on LinkedIn (Opens in new window)
- Click to share on Facebook (Opens in new window)
- Click to share on Twitter (Opens in new window)
- Click to share on Skype (Opens in new window)
- Click to share on WhatsApp (Opens in new window)
- Click to share on Pocket (Opens in new window)
- Click to share on Tumblr (Opens in new window)
- Click to share on Pinterest (Opens in new window)
- Click to share on Telegram (Opens in new window)
- Click to share on Reddit (Opens in new window)
- Click to print (Opens in new window)
- Click to email this to a friend (Opens in new window)
Related
Meet Paul
You May Also Like

Passing command line settings to SQL Server Integration Services (SSIS) packages using dtexec on Linux
March 1, 2019
Working with aggregations in Power BI Desktop
April 23, 2020