Assigning Users Permission to Access DCS Databases

  • Article

You must assign users (assigned in the services) permissions to access DCS databases. The users must have access to the following databases in the DCS server:

  • Discovery
  • BusinessLog
  • ServiceConfiguration
  • WorkflowPersistenceStore
  • DCSManagementDB

To assign permissions to the users, follow the steps below for each of the above database:

  1. In the DCS Server, open Start -> All programs -> Microsoft SQL Server 2008 -> SQL Server Management Studio.

  2. Expand Databases and select the database you want to assign permissions. The right pane displays all items for the database.

  3. Right-click on Security, and select New -> Users. This displays the New User screen.

  4. Dd632773.033d4bec-8c3c-46a3-8e60-4a2f17388fd8(en-us,TechNet.10).png

  6. Enter the user (assigned in the services) in the User Name and Login Name fields.

  7. In the Database role membership list, select the following permissions for the user:

    • db_accessadmin
    • db_owner
    • db_securityadmin
    • DCS_Admin
    • DCS_Users
    • Public

  9. Repeat this for all the users assigned in the services.

  10. Click Ok