Page 1 of 1

Issue with configuring Salesforce linked server in SSMS

Posted: Mon 06 Mar 2017 14:33
by Vikram
I am not able to add a successfuls linked server connection in SSMS for Salesforce. Below are the steps I followed:

1. Configured and created ODBC DSN using Devart ODBC driver and ODBC creation was created and test connection was success.
2. Tried to create linked server through Server Objects-->Linked Serveres-->New Linked Server. gave the DSN name as it was in ODBC configuration. Linked server is getting created successfully.
But when I try to browse tables its giving me error "cannot initialize the data source object of OLEDB provider "MSDASQL" for linked server "SALESFORCE" (Microsoft SQL Server, Error:7303)

Please help me fixing it.

Re: Issue with configuring Salesforce linked server in SSMS

Posted: Thu 09 Mar 2017 06:59
by MaximG
Please describe the problem in more detail:

a) What account is the 'SQL Server' service (LOCAL SERVICE, NETWORK_SERVICE, etc.) run ?
b) What authentication type are you using: SQL Server : Windows Authentication or SQL Server Authentication?
c) What privileges has the Windows user working with SQL Server Management Studio ?
Make sure that the used driver bitness matches Server Management Studio bitness
In addtition, try to use the solution provided by the link : ... g_ssms.htm