Run DQSInstaller.exe to Complete Data Quality Server Installation

To complete the Data Quality Server installation, you must run the DQSInstaller.exe file after installing SQL Server 2012. This topic describes how to run the DQSInstaller.exe from the Start menu, Windows Explorer, or Command Prompt; you can choose any of the ways to run the DQSInstaller.exe file.

In This Topic

• Prerequisites

• Run DQSInstaller.exe from Start menu or Windows Explorer

• Run DQSInstaller.exe from Command Prompt

Prerequisites

• You must have selected Data Quality Services under Database Engine Services on the Feature Selection page in the SQL Server setup while installing SQL Server, and must have completed the SQL Server installation. For more information, see Install Data Quality Services.

• Your Windows user account must be a member of the sysadmin fixed server role in the SQL Server database engine instance.

• You must be logged on as a member of the Administrators group on the computer where you are running DQSInstaller.exe.

Run DQSInstaller.exe from Start menu or Windows Explorer

1. On the computer where you chose to install Data Quality Server, run the DQSInstaller.exe file using either of the following:

   • Start menu: On the taskbar, click Start, point to All Programs, click Microsoft SQL Server 2012. Under Microsoft SQL Server 2012, click Data Quality Services, and then click Data Quality Server Installer.

   • Windows Explorer: Locate the DQSInstaller.exe file. If you installed the default instance of SQL Server, the DQSInstaller.exe file will be available at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn. Double-click the DQSInstaller.exe file.

2. A command prompt window appears that shows the status of the installation. You will notice the following three things:

   1. The installer creates an installation log file, DQS_install.log, which contains information about the actions performed on running the DQSInstaller.exe file. If you installed the default instance of SQL Server, the DQS_install.log file will be available at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log.

   2. The installer uses the default server collation, SQL_Latin1_General_CP1_CI_AS, for installing Data Quality Server.

      Important

      You can provide a different server collation value for installing Data Quality Server only if you are running DQSInstaller.exe from command prompt. For more information, see Run DQSInstaller.exe from Command Prompt later in this topic.

   3. The installer checks for any pending restarts on your computer owing to any updates that have been recently installed on your computer. If any pending restarts are found, a message appears to notify you about the same, and you can choose to continue or abort the installation by pressing Y or N respectively. We recommend that if there are any pending restarts, you must abort the installation, restart your computer, and then run the DQSInstaller.exe again.

3. You are prompted to type a password for the database master key. The database master key is required to encrypt the reference data service provider keys that will be stored in the DQS_MAIN database when you set up reference data providers in Data Quality Services (DQS) later.

   Important

   The password must be at least 8 characters long, and must contain characters from three of the following four categories: English upper case letter (A, B, C,… Z), English lowercase letter (a, b, c,… z), Numeral (0, 1, 2,… 9), and nonalphanumeric or special character (~!@#$%^&*()_-+=|\{}[]:;"'<>,.?/). For example: P@ssword. The installer will prompt you to enter another password if the current password does not match the requirement.

4. Provide a password, confirm the password, and then press ENTER to continue with the installation.

   Important

   You must retain the password specified for the database master key because you will require it while restoring the DQS databases from a backup in future, if you choose to do so. For more information about restoring DQS databases, see Backing Up and Restoring DQS Databases.

5. If a Master Data Services database is present in the same SQL Server instance as Data Quality Server, the installer creates a user mapped to the Master Data Services login, and grants it the dqs_administrator role on the DQS_MAIN database. For information about installing Master Data Services and creating a Master Data Services database, see Install Master Data Services.

6. A completion message is displayed after the installation has completed successfully. Press any key to close the command prompt window.

Run DQSInstaller.exe from Command Prompt

You can run DQSInstaller.exe from command prompt using the following command-line parameters:

dqsinstaller.exe –collation <collation_name>

dqsinstaller.exe -upgradedlls

dqsinstaller.exe –exportkbs <path><filename>

dqsinstaller.exe –importkbs <path><filename>

dqsinstaller.exe -upgrade

To run DQSInstaller.exe from Command Prompt:

1. Start Command Prompt.

2. At the command prompt, change your directory to the location where DQSInstaller.exe is available. If you installed the default instance of SQL Server, the DQSInstaller.exe file will be available at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn:

   cd C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn
   

3. At the command prompt, run DQSInstaller.exe with or without command-line parameters:

   • Without Command-Line Parameter: Type dqsinstaller.exe, and then press ENTER.

   • With Command-Line Parameter: Type the required command as mentioned in the table above, and then press ENTER.

4. The required actions are performed based on the specified command. If you just chose to install Data Quality Server without any command-line parameters, rest of the steps are same as described in steps 2-6 in the previous section, Run DQSInstaller.exe from Start menu or Windows Explorer.

Next Steps

• Grant appropriate DQS roles to users based on their work profile. See Grant DQS Roles to Users.

• If Data Quality Server will be accessed remotely from Data Quality Client, enable the TCP/IP protocol using SQL Server Configuration Manager on this computer. See Enable TCP/IP Network Protocol for SQL Server.

• Make sure that you can access your source data for the DQS operations, and can export the processed data to a table in a database. See Access Data for the DQS Operations.

See Also

Tasks

Upgrade SQLCLR Assemblies After .NET Framework Update

Export and Import DQS Knowledge Bases Using DQSInstaller.exe

Concepts

Install Data Quality Services