This project has moved and is read-only. For the latest updates, please go here.

Previous Install Semantic Search Manual Install Install Replication Distributor Next


Install Data Quality Services

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.

The SQL 2012 RTM version of Data Quality Services cannot be configured for a Clustered install of SQL Server. It is recommended that for SQL 2012 you use at least RTM CU1 if you want to install Data Quality Services. The SQL 2012 RTM CU1 version introduces support for installing on a cluster and numerous performance and schema improvements. This problem does not exist for SQL 2014.

Data Quality Services home page
Data Quality Services download SQL 2012 CU1 can be downloaded from
Data Quality Services tutorial
Data Quality Services FAQ
Data Quality Services video

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:

Install Parameter Build SQL2005 SQL2008 SQL2008R2 SQL2012 SQL2014
SetupDQ FULL N/A N/A N/A No No

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:


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:

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

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 "DQSPassword"

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


2) Run the following commands to setup DQS Operator rights


Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements

Previous Install Semantic Search Top Install Replication Distributor Next

Last edited Oct 23, 2014 at 12:31 PM by EdVassie, version 19