Export (0) Print
Expand All

Manage DQS Users in SSMS

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.

Security

Permissions

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.

Arrow icon used with Back to Top link [Top]

  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.

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

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

Arrow icon used with Back to Top link [Top]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft