Install Data Quality Services

Previous Install Semantic Search	Manual Install	Install Replication Distributor Next

FineBuild can install Data Quality Services as part of the SQL Server install process.

Data Quality Services is written by Microsoft. It was chosen to be included in FineBuild because it configures a core component of SQL 2012 and above that provides a knowledge-driven data cleansing solution.

The Microsoft SQL Server install process will install the Data Quality Services Client and the Data Quality Services Server components, and some post-installation configuration is needed before the Server component is available for use. The FineBuild processing for Data Quality Services performs this configuration.

Please note The Setup Data Quality Databases process will often take about 40 minutes to complete.

SQL2012 RTM Only The SQL 2012 RTM version of Data Quality Services cannot be configured for a Clustered install of SQL Server. For SQL2012 it is recommended that if you want to use Data Quality Services that you use at least RTM CU1 as this introduces support for installing on a cluster and numerous performance and schema improvements.

Item	Link
Data Quality Services home page	https://social.technet.microsoft.com/wiki/contents/articles/15504.community-resources-for-data-quality-services-dqs.aspx
Data Quality Services FAQ	https://social.technet.microsoft.com/wiki/contents/articles/3919.data-quality-services-dqs-faq.aspx
Data Quality Services video	https://www.youtube.com/watch?v=XvEsVxpNadc

FineBuild Data Quality Services Install

Automated silent installation of Data Quality Services is performed by Process Id 4SM and is controlled by the parameters below:

SQL Version	Parameter	FULL Build	WORKSTATION Build	CLIENT Build
SQL2019	/SetupDQ:	No	Yes	No
SQL2017	/SetupDQ:	No	Yes	No
SQL2016	/SetupDQ:	No	Yes	No
SQL2014	/SetupDQ:	No	Yes	No
SQL2012	/SetupDQ:	No	Yes	No
SQL2008R2	/SetupDQ:	N/A	N/A	N/A
SQL2008	/SetupDQ:	N/A	N/A	N/A
SQL2005	/SetupDQ:	N/A	N/A	N/A

FineBuild also uses the following parameters to help install Data Quality Services:

Parameter	Default Value	Description
/DQPassword:	/sapwd: value	Password for DQS Administrator. This must comply with normal Windows password rules. It will default to the sa account password if not specified. The password should be recorded in the DBA Password Store.

FineBuild will not by default install Data Quality Services, because most sites do not need this functionality.

If you want FineBuild to install Data Quality Services, then you must add the following parameter when you run FineBuild:

/SetupDQ:Yes

If you are installing on a Cluster, FineBuild will automatically fail over SQL Server to run on the node you are working on in order that the Data Quality Services install can work.

The FineBuild install for Data Quality Services includes the following:

• Install Data Quality Services components (part of the SQL Server install process)
• Setup Data Quality Databases
• Move Data Quality Log File
• Setup Data Quality Security

Top

---

Manual Data Quality Services Install

The following steps show what you would have to do to configure Data Quality Services manually. FineBuild does all of this work for you automatically.

Setup Data Quality Databases

This section will create the Data Quality Services databases and install the DQS CLR routines. In the following commands, if a named instance has been installed, use the instance name in place of MSSQLSERVER. This process will often take about 40 minutes to complete.

1. If you are installing on a Cluster, SQL Server must be running on the cluster node you are adding to the cluster.

2. Click on Start, then Run, and type CMD to open a Command Window.

3. Type in the drive letter used for the DrvProg parameter

4. Type the following command to navigate to the SQL Server programs folder.

   CD "Program Files/Microsoft SQL Server/MSSQL._MSSQLSERVER_/MSSQL/Binn"
   

5. Run the following command to run the Data Quality Services server configuration program. The password must comply with normal Windows password requirements.

   DQSInstaller -instance MSSQLSERVER -catalog "DQS" -password "<span style="color:#0000ff">DQSPassword</span>"
   

6. When the installation is complete, press Enter to close the DQSInstaller window.

Move Data Quality Log File

The DQS Installer log file is moved to the FineBuild log folder, so that all install log files are in one place.

1. Copy the following file:

   Source	Destination
   DQS_install.log	DrvProg:\Program Files\Microsoft SQL Server\FineBuildLogs

Setup Data Quality Security

The DBA sysadmin is given Administrator rights within DQS, and the DBA non-sysadmin group is given Operator rights.

1. Start SQL Server Management Studio (SSMS) and run the following commands to setup DQS Administrator rights

   Replace GroupDBA with your Windows DBA Sysadmin Group

   USE DQS_MAIN
   GO
   CREATE USER _**GroupDBA**_ FOR LOGIN [**_GroupDBA_**}
   EXEC SP_ADDROLEMEMBER @ROLENAME='dqs_administrator', @MEMBERNAME='_**GroupDBA**_'
   

2. Run the following commands to setup DQS Operator rights

   Replace GroupDBANonSA with your Windows DBA Non-Admin Group

   USE DQS_MAIN
   GO
   CREATE USER **GroupDBANonSA** FOR LOGIN [_**GroupDBANonSA**_]}
   EXEC SP_ADDROLEMEMBER @ROLENAME='dqs_kb_operator', @MEMBERNAME='_**GroupDBANonSA**_'
   

Copyright FineBuild Team © 2011 - 2020. License and Acknowledgements

Previous Install Semantic Search	Top	Install Replication Distributor Next