1

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.

Improve this question
3
  • Is SQL Authentication not going to be supported on the new SQL 2008 server? Commented Mar 14, 2013 at 1:08
  • Have you considered a jumpbox/management server (security wise also more a best practice) Commented Jul 2, 2022 at 3:09
  • This might be helpful also: catbaba.com/… Commented Jul 2, 2022 at 3:13

1 Answer 1

Reset to default
0

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.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.