question

SQLDBA123 avatar image
SQLDBA123 asked

Windows authentication conenction from Linux client to SQL Server Database

Please can anyone suggest or give link , how to configure/connect SQL Server database from Linux machine using Windows authentication? We connected using sql authentication,but want to go with Windows authentication. Thanks
sql serverconnection
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tom Staab avatar image
Tom Staab answered
I have no first-hand experience with this, but I found the question intriguing, so I did some research. The first section of [this][1] article is titled "Using Integrated Authentication to Connect to SQL Server from an ODBC Application". Part of the explanation there said "Ensure that the Linux principal server that is going to connect to SQL Server is already authenticated with the Kerberos KDC." That lead me to [this article][2] titled "Integrating a Linux Host with a Windows AD for Kerberos SSO authentication". I hope that helps. It looks good from just reading it, but I have no Linux environment with which to test it. Good luck, and please let us know what worked once you get it working. [1]: http://technet.microsoft.com/en-us/library/hh568450(v=sql.110).aspx [2]: http://www.safesquid.com/content-filtering/integrating-linux-host-windows-ad-kerberos-sso-authentication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.