I would like to set my current mssql db (2008 and 2012) to authenticate using a linux kerberos server that I have in my environment .

The windows station is in a workgroup and I would like to avoid having to setup a domain controller and active directory .

How can I accomplish that ? what do I need to configure on the windows side and the kerberos server side (assuming it's configured already to work with other dbs running on linux based OSes) ?


Yes this is manageable. All you need is a trusted connection to an odbc connector and you can read about that here: http://technet.microsoft.com/en-us/library/hh568450.aspx

  • Thanks @robwahl for the answer. I need to configure it for jdbc which I did , but I'm getting some error message 'Server not found in Kerberos database Application/Function: Anything that makes a service ticket request. Potential Causes and Solution: The account for the service principal name being requested doesn't exist in Active Directory or is incorrect in Active Directory. This could also indicate a DNS problem.' any hints? – John Doe Mar 31 '14 at 12:20

I suspect that you're going to have to "trick" windows into natively authenticating against the linux kerberos server, which might be more effort than you're looking for. Things I found include:

Or, you could use SQL Server authentication instead.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.