Search results matching tags 'DQS' and 'Master Data Services'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=DQS,Master+Data+Services&orTags=0Search results matching tags 'DQS' and 'Master Data Services'en-USCommunityServer 2.1 SP2 (Build: 61129.1)WCF Error when using “Match Data” function in MDS Excel AddInhttp://sqlblog.com/blogs/davide_mauri/archive/2012/03/29/wcf-error-when-using-match-data-function-in-mds-excel-addin.aspxThu, 29 Mar 2012 07:46:16 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:42542manowar<p>If you’re using MDS and DQS with the Excel Integration you may get an error when trying to use the “Match Data” feature that uses DQS in order to help to identify duplicate data in your data set.</p> <p>The error is quite obscure and you have to enable WCF error reporting in order to have the error details and you’ll discover that they are related to some missing permission in MDS and DQS_STAGING_DATA database.</p> <p>To fix the problem you just have to give the needed permession, as the following script does:</p> <p><font face="Courier New">use MDS <br />go</font></p> <p><font face="Courier New">GRANT SELECT ON mdm.tblDataQualityOperationsState TO [VMSRV02\mdsweb] <br />GRANT INSERT ON mdm.tblDataQualityOperationsState TO [VMSRV02\mdsweb] <br />GRANT DELETE ON mdm.tblDataQualityOperationsState TO [VMSRV02\mdsweb] <br />GRANT UPDATE ON mdm.tblDataQualityOperationsState TO [VMSRV02\mdsweb]</font></p> <p><font face="Courier New">USE [DQS_STAGING_DATA] <br />GO <br />ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [VMSRV02\mdsweb] <br />ALTER AUTHORIZATION ON SCHEMA::[db_datawriter] TO [VMSRV02\mdsweb] <br />ALTER AUTHORIZATION ON SCHEMA::[db_ddladmin] TO [VMSRV02\mdsweb] <br />GO</font> <br /></p> <p>Where “VMSRV02\mdsweb” is the user you configured for MDS Service execution. If you don’t remember it, you can just check which account has been assigned to the IIS application pool that your MDS website is using:</p> <p><a href="http://sqlblog.com/blogs/davide_mauri/image_20B72F32.png"><img style="background-image:none;border-bottom:0px;border-left:0px;padding-left:0px;padding-right:0px;display:inline;border-top:0px;border-right:0px;padding-top:0px;" title="image" border="0" alt="image" src="http://sqlblog.com/blogs/davide_mauri/image_thumb_177AF3F1.png" width="897" height="204" /></a></p>