Unable to login to the SQL Server Authentication

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
czaleski
Posts: 3
Joined: Thu 14 Mar 2019 19:48

Unable to login to the SQL Server Authentication

Post by czaleski » Fri 15 Mar 2019 14:14

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
Last edited by czaleski on Wed 20 Mar 2019 12:12, edited 1 time in total.

MaximG
Devart Team
Posts: 1338
Joined: Mon 06 Jul 2015 11:34

Re: Unable to login to the SQL Server Authentication

Post by MaximG » Tue 19 Mar 2019 11:23

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

czaleski
Posts: 3
Joined: Thu 14 Mar 2019 19:48

Re: Unable to login to the SQL Server Authentication

Post by czaleski » Wed 20 Mar 2019 12:12

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

MaximG
Devart Team
Posts: 1338
Joined: Mon 06 Jul 2015 11:34

Re: Unable to login to the SQL Server Authentication

Post by MaximG » Mon 25 Mar 2019 06:33

Please perform the following steps :

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

czaleski
Posts: 3
Joined: Thu 14 Mar 2019 19:48

Re: Unable to login to the SQL Server Authentication

Post by czaleski » Mon 25 Mar 2019 11:35

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!

MaximG
Devart Team
Posts: 1338
Joined: Mon 06 Jul 2015 11:34

Re: Unable to login to the SQL Server Authentication

Post by MaximG » Thu 28 Mar 2019 06:28

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

Post Reply