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 SQL 2012 component 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 RTM version of Data Quality Services cannot be configured for a Clustered install of SQL Server. It is recommended that you use at least RTM CU1 if you want to install Data Quality Services. The RTM CU1 version introduces support for installing on a cluster
and numerous performance and schema improvements.
FineBuild Data Quality Services Install
Automated installation of Data Quality Services is performed by Process Id
4SM and is controlled by the parameters below:
||SQL 2008 R2
FineBuild also uses the following parameters to help install Data Quality Services:
||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
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:
||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
CREATE USER GroupDBA FOR LOGIN [GroupDBA]}
EXEC SP_ADDROLEMEMBER @ROLENAME='dqs_administrator', @MEMBERNAME='GroupDBA'
2) Run the following commands to setup DQS Operator rights
CREATE USER GroupDBANonSA FOR LOGIN [GroupDBANonSA]}
EXEC SP_ADDROLEMEMBER @ROLENAME='dqs_kb_operator', @MEMBERNAME='GroupDBANonSA'
Copyright © 2011 - 2013 Edward Vassie.
License and Acknowledgements