[freetds] login problem with sql 2000
Frediano Ziglio
freddyz77 at tin.it
Sun Jun 19 05:10:00 EDT 2005
Il giorno dom, 19/06/2005 alle 03.42 -0400, Jeremy Kister ha scritto:
> I'm having problems connecting to a mssql server (that I am not the
> administrator of), which requires domain logins. The error I'm getting is:
>
> Login failed for user '(null)'. Reason: Not associated with a trusted
> SQL Server connection
>
> I'm using freetds 0.63 (tsver 8.0) with DBD::Sybase 1.05, and perl
> 5.8.3. I've also tried tdsver 7.0.
>
> http://www.freetds.org/userguide/domains.htm says the problem is likely
> that the server is configured to only use Named Pipes for
> authentication. Before I contact the administrator of the sql box, I
> want to get my ducks lined up.
>
> Is it true that this could be a named pipes problem, even though I can
> make a socket to the server on port 1433/tcp, and can /not/ make sockets
> to 135/139/445 ?
>
Port 139 and 445 are for SMB/CIFS services (NT Named Pipes use these
protocols). Port 1433 is mssql protocol port (supported by FreeTDS), if
you can telnet to 1433 you can make a direct connection to mssql without
NT Named Pipes.
> is there reasoning against setting the "Send LM & NTLM responses", as
> the FreeTDS site suggests ?
>
Simply FreeTDS do not still support NTLM2.
freddy77
More information about the FreeTDS
mailing list