ODBC connection, or other from Linus system using AD account details 2

[mrmovie]

Hi All, I think I am surpised to find that you cannot create an ODBC connection from a Linus system specifying AD account details in the connection string? that only a local SQL account being specified will work, that to use an AD account you need to choose one of the integrated options in the connection string and therefore the process needs to be running under that AD account....you cannot explicitly specify it in the connection string?

Can anyone advise how I can connect to a SQL DB, from linux, using an AD accounts credentials?

Thanks,
MrMovie

I Hear, I Forget
I See, I Remember
I Do, I Understand

Ronald McDonald

 

[fredericofonseca]

look at

https://www.google.ie/search?ei=zUP.......0...1c..64.psy-ab..0.0.0....0.Yc0KK3wzS6A

not sure about the ODBC bit, but the linux server itself needs to be correctly configured and part of the domain.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[mrmovie]

Thanks Frederico, I also found this MS article which describes an implementation:
Connecting to SQL from Linux is possible using Kerberos, according to this Microsoft documentation,

https://docs.microsoft.com/en-us/sq...ntegrated-authentication?view=sql-server-2017

I Hear, I Forget
I See, I Remember
I Do, I Understand

Ronald McDonald