Permissions for setting up linked server with out-of-process provider

This topic explains how to proceed to have all required permissions for setting up a linked server with out-of-process provider.

Verify below settings in DCOMCNFG

Procedure

1. Open Component Services > My Computer > Properties and in the Default Properties tab do the following:

   1. Verify that Enable Distributed COM on this computer is selected.

   2. Verify that Default Authentication is set to Connect.

   3. Verify that Default Impersonation Level is set to Identify or Impersonate.

2. Open Component Services > MyComputer > DCOM Config > MSDAINITIALIZE and do the following:

   1. Right-click MSDAINITIALIZE > Properties > Security.

   2. Add the SQL Server service account under Launch and Activation Permissions, Access Permissions, and Configuration Permissions.

   3. Provide full rights to the account.

3. Restart the SQL Server.

4. Run SSMS as administrator to use out-of-process Linked Server.