Configure DCOM settings for out-of-process configuration

If you set the PISQLClient provider to run out-of-process, you need to configure DCOM settings. If you are using Windows Server 2008, see the Microsoft Developer blog, How to enable all the elements of the DCOM Config (DCOMCNFG.EXE) security tab on Windows Server 2008 R2?

1. From the Windows Start menu, click Administrative Tools > Component Services.

2. Right-click My Computer and select Properties.

   The My Computer Properties window opens.

3. On the Default Properties tab, set the following:

   • Select the Enable Distributed COM on this computer check box.

   • Set the Default Authentication Level to Connect.

   • Set the Default Impersonation Level to Identify or Impersonate.

   

4. Click OK.

5. In the Component Services window, navigate to My Computer > DCOM Config > MSDAINITIALIZE, and then right-click MSDAINITIALIZE and select Properties.

   The MSDAINITIALIZE Properties window opens.

6. On the Security tab, in the Launch and Activation Permissions area, select Customize and click Edit.

   

7. In the Launch and Activation Permissions window, add each user account that will query the SQL Server.

   Note: If there are a large number of accounts to add, you may want to create a Windows Active Directory group for them and add the group here.

8. For each user account or group you added, select the user or group and, in the Permissions area, select the Allow check boxes for Local Launch and Local Activation.

   

9. When you have finished adding accounts, click OK.

10. On the Security tab of the MSDAINITIALIZE Properties window, in the Access Permissions area, select Customize and click Edit.

11. In the Access Permission window, add the user account that is running SQL Server and, in the Permissions area, select the Allow check box for Local Access.

12. Click OK.

13. On the Security tab of the MSDAINITIALIZE Properties window, in the Configuration Permissions area, select Customize and click Edit.

    Note: You do not need to set Configuration Permissions if the users already have Read access here.

14. In the Change Configuration Permission window, add each user account or Active Directory group that will query the SQL Server and, in the Permissions area, select the Allow check box for Read.

15. Click OK.

16. In the MSDAINITIALIZE Properties window, click OK.

17. Close the Component Services window.