2

I'm pretty sure I am going to have to expand upon this a bit as I am new, and my question is probably not clear.

I have an Active Directory environment that includes a Microsoft SQL Server running Windows Server. The SQL server is using "Windows Authentication Mode." It looks like Microsoft does not support "Windows Authentication Mode" when using sqlcmd from Linux unless it's Azure (correct me if I am wrong), so I am trying to create a service account and then generate a Kerberos ticket for that account. The problem is I am not even sure where to start. I did find some information around how-to create a service account and, maybe, a Kerberos ticket for that. But how do I use this on Linux afterward? If you know some existing guides that I missed on this topic feel free to point me there.

Thanks

Improve this question
0

1 Answer 1

Reset to default
1

Try this guide: Tutorial: Use Active Directory authentication with SQL Server on Linux

And then go to point:
Connect to SQL Server using AD Authentication

Basically you will need to ssh to the client using your AD credentials and the run sqlcmd without credentials

ssh -l [email protected] client.contoso.com  
sqlcmd -S mssql-host.contoso.com
Improve this answer
3
  • 1
    Hmm, this would work if the server was a Linux which, I now realize, I did not describe in the question so that is on me. The server running MS SQL is a Windows Server. Commented Nov 26, 2019 at 5:53
  • Point "Connect to SQL Server using AD Authentication" is about the client. Guide is for client and/or server on linux. Commented Nov 26, 2019 at 15:18
  • 1
    Did you find a solution, @Petter? Commented May 14, 2020 at 18:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.