[freetds] Error connecting to SQL Server 8.0 using tsql

Hugo Barbosa hugo.barbosa at gmail.com
Fri Dec 10 06:06:43 EST 2004


Hi there,

I'm using FreeTDS 0.62 and Fedora Core 2, trying to connect to MS SQL
Server 8.0 in Windows 2000. The installation of FreeTDS was OK, but
when I try to connect to the server using tsql, the following message
is returned:

------------------------------
locale is "pt_BR"
locale charset is "ISO-8859-1"
Password:
Msg 20004, Level 9, State 0, Server OpenClient, Line 0
Read from SQL server failed.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server
------------------------------

The same message is returned if I use "-S server_name" or "-H
host_name -p port".

But if I try to connect using Telnet, or Terminal Server of Fedora,
everything is OK. The user exists in the server, and the same error
occurs if I try server login or domain login. I even created a server
user with the same ID and password than the domain user (I mean, I had
the user "DOMAIN/Administrator" and created the user in SQL Server
"Administrator"). The same error occurs.

I wil paste my log, hoping that someone can help me.

------------------------------
Starting log file for FreeTDS 0.62.4
        on 2004-12-10 08:55:20 with debug level 99.
names for ISO-8859-1: ISO-8859-1
names for UTF-8: UTF-8
names for UCS-2LE: UCS-2LE
names for UCS-2BE: UCS-2BE
iconv to convert client-side data to the "ISO-8859-1" character set
08:55:20.282097 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
08:55:20.282150 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
08:55:20.282173 Connecting to 10.11.120.83 port 3389, TDS 8.0.
08:55:20.282651 tds_put_string converting 25 bytes of
"serpro-1432911.bsa.serpro"
08:55:20.282695 tds_put_string wrote 50 bytes
08:55:20.282706 tds_put_string converting 5 bytes of "admin"
08:55:20.282718 tds_put_string wrote 10 bytes
08:55:20.282730 tds_put_string converting 4 bytes of "TSQL"
08:55:20.282741 tds_put_string wrote 8 bytes
08:55:20.282752 tds_put_string converting 10 bytes of "teste_code"
08:55:20.282763 tds_put_string wrote 20 bytes
08:55:20.282783 tds_put_string converting 11 bytes of "TDS-Library"
08:55:20.282794 tds_put_string wrote 22 bytes
08:55:20.282805 tds_put_string converting 10 bytes of "us_english"
08:55:20.282816 tds_put_string wrote 20 bytes
08:55:20.282826 tds_put_string wrote 0 bytes
08:55:20.282867 tds_process_login_tokens()
08:56:20.287728 goodread: errno=104, "Connection reset by peer"
08:56:20.287809 tds_client_msg: #20004: "Read from SQL server
failed.".  Connection state is now 0.
08:56:20.287842 looking for login token, got  0()
08:56:20.287857 tds_process_default_tokens() marker is 0()
08:56:20.287868 leaving tds_process_default_tokens() connection dead
08:56:20.287888 tds_client_msg: #20014: "Login incorrect.". 
Connection state is now 4.
------------------------------

Looks like the error starts at the 'errno=104, "Connection reset by
peer"', but I have no idea why this happens. Thanks for your help. :)

-- 
Hugo.

---------------------------------------------------------------------------------
"Do rio que tudo arrasta se diz que é violento
 Mas ninguém diz violentas as margens que o oprimem"

                                Bertold Brecht - Sobre a violência
---------------------------------------------------------------------------------


More information about the FreeTDS mailing list