Edit SQL Native Client Provider properties

Perform these steps on both the repository and data mart servers.

  1. Navigate to Server Objects > Linked Servers > Providers.
  2. Right-click the SQL Native Client Provider for linked servers and select Properties.
  3. On the General page, select Allow inprocess.
  4. Click OK.