| title | Grant DQS Roles to Users |
|---|---|
| ms.date | 03/01/2017 |
| ms.prod | sql |
| ms.prod_service | data-quality-services |
| ms.reviewer | |
| ms.technology | data-quality-services |
| ms.topic | conceptual |
| ms.assetid | afb445b5-bdbe-4bfe-844f-344766cdc2b2 |
| author | swinarko |
| ms.author | sawinark |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly]
This topic describes how to create SQL logins based on a Windows principal, and grant [!INCLUDEssDQSnoversion] (DQS) roles on the DQS_MAIN database.
-
You must have completed the [!INCLUDEssDQSServer] installation by running the DQSInstaller.exe file. For more information, see Run DQSInstaller.exe to Complete Data Quality Server Installation.
-
Your Windows user account must be a member of the appropriate fixed server role (such as securityadmin, serveradmin, or sysadmin) to create SQL login, and grant them DQS roles.
-
Start [!INCLUDEssManStudioFull].
-
In [!INCLUDEssManStudioFull], expand your SQL Server instance, and then expand Security.
-
Right-click the Security folder, point to New, and then click Login.
-
In the Login - New dialog box, specify the name of a Windows user in the Login name box, specify the type of authentication as Windows authentication, and click Search to validate the user.
-
After the user is validated, click the User Mapping page in the left pane.
-
In the right pane, select the check box under the Map column for the DQS_MAIN database, and then select the dqs_administrator, dqs_kb_editor, or dqs_kb_operator check box in the Database role membership for: DQS_MAIN pane, depending on the access level needed for the user. For information about the three DQS roles, see DQS Security.
-
In the Login - New dialog box, click OK to apply the changes.
[!NOTE]
If you grant the dqs_administrator role to a user, apply the changes, and then recheck the user permissions, the other two DQS roles check boxes (dq_kb_editor and dqs_kb_operator) are also selected.
Try logging on to [!INCLUDEssDQSServer] by using the Windows user account for which you just created a SQL login, and granted a DQS role.