Manage DQS Users in SSMS


Applies To: SQL Server 2016

This topic describes how to create additional users in the SQL Server instance using SQL Server Management Studio, and grant them appropriate Data Quality Services (DQS) roles on the DQS_MAIN database.



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 appropriate DQS roles.

  1. Start Microsoft SQL Server Management Studio.

  2. In Microsoft SQL Server Management Studio, expand your SQL Server instance, and then expand Security.

  3. Right-click the Security folder, point to New, and then click Login.

  4. 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.

    System_CAPS_ICON_note.jpg Note

    DQS only supports Windows authentication; SQL Server authentication is not supported.

  5. After the user is validated, click the User Mapping page in the left pane.

  6. 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.

  7. In the Login – New dialog box, click OK to apply the changes.

    System_CAPS_ICON_note.jpg 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.

Community Additions