This project has moved. 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 http://blogs.msdn.com/b/dqs/
Data Quality Services download SQL 2012 CU1 can be downloaded from http://support.microsoft.com/kb/2679368
Data Quality Services tutorial http://blogs.msdn.com/b/dqs/archive/2011/07/21/learning-resources-for-dqs-in-sql-server-denali-ctp3.aspx
Data Quality Services FAQ http://social.technet.microsoft.com/wiki/contents/articles/3919.aspx#Q_1_What_is_data_quality
Data Quality Services video http://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:

Install Parameter Build SQL2005 SQL2008 SQL2008R2 SQL2012 SQL2014
SetupDQ FULL N/A N/A N/A No No
SetupDQ WORKSTATION N/A N/A N/A No No
SetupDQ CLIENT 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:

/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:


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

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

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


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