Need connect string to connect from Linux to SQL Server using an A/D group name

• Express12

  SSCoach

  Points: 18518

  More actions

  July 8, 2019 at 8:18 pm

  #3660930

  ISO way to setup a connection string to connect from Linux to SQL Server using an A/D group name. (we do NOT want to use a SQL Login!)

  - this link details the setup for a Linux connection to a SQL Server database: https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-Linux

  - one of the final instructions during setup is to add a connection string which appears to be using a SQL Login which we do NOT want to use as it violates our companies security policy. We're trying to omit all SQL Logins and utilize Active Directory security in connection strings

  BT

• Andrey

  SSC Eights!

  Points: 840

  More actions

  July 9, 2019 at 9:27 am

  #3661046

  You can't use AD group name , you can connect under AD account which is a member of AD group which does have access to SQL server.

  https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/using-integrated-authentication?view=sql-server-2017

  If you specify anything like username & password in the connection string, SQL server thinks it's SQL account.

  So, in case of AD authentication, in your connection string should be "Trusted_Connection=yes" clause.