[freetds] Connecting to MS SQL 2000 via Windows Authentication

Steve Langasek vorlon at netexpress.net
Sat Dec 21 12:37:29 EST 2002


Hi Daniel,

On Sat, Dec 21, 2002 at 12:29:04PM -0500, Daniel Morgan wrote:

> Can FreeTDS connect to a Microsoft SQL Server 2000 database via Windows
> Authentication from a non-Windows machine?

> If so, how does FreeTDS do it?

> To be honest, I don't know anything about this security stuff.  I just would
> like the ability to connect to MS SQL 2000 from a non-Windows machine using
> "Integrated Securtiy".  If you know how, can you provide the details please?

Yep.  In versions 0.60 and above, FreeTDS can negotiate NTLMSSP auth
with a Windows SQL server.  This is done by setting the option 'try
domain login = yes' in your freetds.conf.  You can also adjust the 'nt
domain' and 'cross domain login' options to taste.

FreeTDS does not yet do Kerberos-based authentication to SQL 2000
servers, but NTLM passwords should still work fine.

Regards,
-- 
Steve Langasek
postmodern programmer
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20021221/1bd56d81/attachment.bin


More information about the FreeTDS mailing list