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 have been using Navicat SQL on Mac (Snow Leopard) to connect to MS 2005 via "Basic Auth" and all is good. However the DB is now being migrated to MS 2008 and try as I might I cant get on via Windows Auth. I get the message...

[FreeTDS][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [FreeTDS][SQL Server]Unable to connect to data source

Any Ideas would be v greatfuly accepted. Many Thanks.

share|improve this question
1  
What have you tried so far to troubleshoot? –  tristan Mar 13 '13 at 22:07
    
Is SQL Authentication not going to be supported on the new SQL 2008 server? –  mrdenny Mar 14 '13 at 1:08

1 Answer 1

Please note that Navicat needs to use NTLM for SQL Server connection. You can check the registry key value to see whether it supports responses. If it is set to 5, it will refuse NTLM responses. See http://www.sqlpanda.com/2013/06/ntlmv2-and-freetds.html.

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.