DQS is only available in the Enterprise Edition and in the Business Intelligence Edition. When installing SQL Server 2012 you can find Data Quality Services under Instance Features and Data Quality Client under the Shared Features.
 |
| DQS - Service and Client |
Second installation
When you finished your SQL Server installation you need to do a second installation. In the start menu you will find in the Data Quality Services folder an installation shortcut.
 |
| Start menu - DQS |
Clicking this will install DQS with a default collation (SQL_Latin1_General_CP1_CI_AS). If you want an other collation you need to install DQS via the command prompt:
dqsinstaller.exe –collation Finnish_Swedish_CS_AS
 |
| DQS installation 'interface' |
Enter, confirm (and remember) a Database Master Key password:
 |
| Database Master Key password |
Wait a couple of miniutes:
 |
| Finished |
The result
If you open SQL Server Management Studio (SSMS) and explorer the instance where DQS was installed you see three new databases.
Connecting with Data Quality Client tool
Now you can use the Data Quality Client to connect to DQS. If you try to login to your local machine and you get a System.Data.SqlClient.SqlException (0x80131904), then you probably got multiple SQL instances or the windows service SQL Server (SQL2012) wasn't started.
 |
| Add intance name in case of multiple SQL intances |
Connected:
 |
| Connected to local DQS |
No comments:
Post a Comment