• Uncategorized

About python : Python—SQL-ODBC-login-with-active-directory-authentication-using-user-name-password

Question Detail

Is there a way to login to SQL server from Linux server using “ODBC Driver 17 for SQL Server” by passing active directory UID & PWD (not using Trusted_Connection=Yes option).

I tried with below connection parameters but getting error:

  1. “Driver=ODBC Driver 17 for SQL Server;MultiSubnetFailover=Yes;UID=;PWD=;Server=;Database=;”
    Error: Login failed

  2. “Driver=ODBC Driver 17 for SQL Server;MultiSubnetFailover=Yes;UID=;PWD=;Server=;Database=;Authentication=ActiveDirectoryPassword”;

    Error: SSL Provider: SSL routines: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed: self signed certificate]

Is there a way to get achieve this?

Question Answer

No answer for now.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.