Devart Forums

SQL Server 2017 - Salesforce- ODBC drivers
I receive an error of 233 or 18456 Login failed when trying to login. I need to obtain the attached certificates and/or match the encryption from Salesforce to SQL Server.
There was a step by step guide about 5 months ago on this site that assisted us in this process that has since been deleted.
Any assistance would be greatly appreciated.

Update to a new error of 7399

Please describe in detail the moment when you get the errors you described. If they occur when trying to establish a connection with SQL Server 2017, you should contact the customer support of this product or look through the specialized forums for a solution. To learn how to set up our driver in the SQL Server Management Studio environment, please refer to:

https://www.devart.com/odbc/salesforce/ ... ager_s.htm
https://www.devart.com/odbc/salesforce/ ... g_ssms.htm

I have created a linked server and I am trying to connect after installing and configuring the drivers
The error reads An exception occured while executing a transact sql statement or batch
The oledb provider msdasql for linked server SALESFORCE reported an error, access denied.
Cannot obtain the required interface from ole db provider msdasql for linked server SALESFORCE microsoft sql server error 7399
thank you

Please perform the following steps :

- use SQL Server Authentication instead of Windows Authentication
- try running NT SERVICE\MSSQLSERVER under your Windows user name

Thank you for all the links and help throughout this process, I actually ended up uninstalling and reinstalling and found the missing link was in the way it was originally installed. It is working perfectly now.
thank you!

We are glad to see the problem resolved. Please don't hesitate to contact us with questions concerning our product usage.