Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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) ?

share|improve this question

2 Answers 2

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

share|improve this answer
    
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 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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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