Granting CRM Deployment Administrators Permissions to CRM SQL Objects

When you add a Deployment Administrator role to a user, Deployment Manager does not add the required permissions on the instance of SQL Server where the Microsoft Dynamics CRM databases are stored. When the user tries to start Deployment Manager, the user might receive an error message that says, "Unable to access the MSCRM_CONFIG database. SQL Server does not exist or access denied." To resolve this issue, you must add the user to SQL log-ins by using Reporting Services. For the new deployment administrator to manage CRM organizations created by other deployment administrators, he or she must be granted db_owner permissions to those databases, or be assigned the sysadmin server role to manage all databases.

  1. Log on to CRMSQL using an account that is a member of Domain Administrators group.

  2. Launch the SQL Server 2008 Management Studio.

  3. On the Connect to Server dialog box, click Connect.

  4. Expand Security.

  5. Right-click Logins and select New Login.

  6. Click the Search button.

  7. In the Select User or Group dialog box, do the following:

    1. Click Object Types, and then enable the Groups type.
    2. Click Locations, and then select Entire Directory.
  8. Click OK.

  9. In the Enter the object name to select text box, type domain group name (that is, CRMDG01Admins), click the Check Names button, and then click OK.

  10. In the Default database drop-down box, select MSCRM_CONFIG.

  11. From the page list on the left, select Server Roles, enable the sysadmin role for the user, and then click OK.

  12. Expand Databases.

  13. Expand the MSCRM_CONFIG database.

  14. Expand Security.

  15. Right-click Users and then select New User.

  16. In the User name field, type the domain user login name (that is, CRMDG01Admins).

  17. In the Login name field, type Contoso\CRMDG01Admins.

  18. In the Database role membership section, select the db_owner check box, and then click OK.

  19. Close the SQL Server 2008 Management Studio.