FreeTDS Development Group

["James K. Lowden" <jklowden AT schemamania.org>]

"Danny Raetzsch" <danny AT msc.tamu.edu> wrote:
> This actually sounds exactly like the problem I'm having (see: 'Login
> Incorrect with MS SQL Server' thread).  Is there any reason FreeTDS
> wouldn't be working with SQL 8.0 or are we both just having the same
> configuration problem?

If your server is from Microsoft and its version is >= 7.0, you won't have
trouble logging in with TDS 7.0.  Microsoft servers all honor TDS 4.2
connections.  SQL Server 2000 supports 8.0, too.  

First time connection problems involve connecting to the server and
authentication.  To make sure it's not a simple network issue, back up and
try telnet (per the user guide).  If you find the machine and the right
port, the server will accept the connection.  

Once you know you have the right address and port, tsql will let you
connect. TDSDUMP will show what ip address and port it's connecting to. 
If you use TDS 4.2, the login packet (including your username and
password) is written to the TDSDUMP log.  

Regardless of TDS version, if you see some reply from the server in the
TDSDUMP log, you found the server.  If you were rejected for reasons of
authentication, you'll see the message to that effect from the server in
the log.  If you get no reply from the server, you didn't find the server.
 

HTH.  

--jkl



> 
> Dan
> 
> 
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of
> fishtail100-freetds AT yahoo.com
> Sent: Thursday, October 14, 2004 11:26 AM
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] Problem connecting to SQL Server 8.0 and XP
> Professional
> 
> Hi,
> 
> I'm trying to connect to SQL Server 8.0 on XP PRO from
> Linux - Redhat 8.0 using freetds 0.62.4. Both
> computers are on the same network and I can both ping
> the box with SQL Server 8.0 and telnet to SQL Server
> 8.0 using the IP and port. 
> 
> I keep getting Login incorrect ... even though I'm
> sure this a correct login. Also, I 've set SQL server
> to allow SQL Server and Windows authentication. I
> don't think the request is getting to SQL Server since
> I don't see any replies in the tds log file, and I
> don't see any authentication requests in the SQL
> Server logs. But this is puzzling since I can clearly
> connect from the linux box to SQL Server ?
> 
> Any help would be greatly appreciated ... Thanks much.
> I've included a transcript of the session and the log
> file below.
> 
> Thanks,
> Mike
> 
> [mhonner@localhost bin]$ export
> TDSDUMP=/tmp/freetds.log
> [mhonner@localhost bin]$ ./tsql -H 192.168.254.2 -p
> 1533 -U mhonner -P XXXXX
> locale is "C"
> locale charset is "ANSI_X3.4-1968"
> 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
> 
> 
> ping 192.168.254.2
> PING 192.168.254.2 (192.168.254.2) 56(84) bytes of
> data.
> 64 bytes from 192.168.254.2: icmp_seq=1 ttl=128
> time=1.28 ms
> 64 bytes from 192.168.254.2: icmp_seq=2 ttl=128
> time=1.27 ms
> 
> telnet 192.168.254.2 1533
> Trying 192.168.254.2...
> Connected to 192.168.254.2.
> Escape character is '^]'.
> Connection closed by foreign host.
> 
> 
> 
> honner@localhost tmp]$ more freetds.log
> Starting log file for FreeTDS 0.62.4
>         on 2004-10-14 10:28:03 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
> "ANSI_X3.4-1968" character set
> 10:28:03.228574 tds_iconv_info_init: converting
> "US-ASCII"->"UCS-2LE"
> 10:28:03.228675 Connecting to 192.168.254.2 port 1533,
> TDS 4.2.
> Sending packet @ 10:28:03.229925
> 0000 02 00 02 00 00 00 00 00-6c 6f 63 61 6c 68 6f 73
> |........ localhos|
> 0010 74 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |t....... ........|
> 0020 00 00 00 00 00 00 09 6d-68 6f 6e 6e 65 72 00 00
> |.......m honner..|
> 0030 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0040 00 00 00 00 00 07 7a 69-6d 62 61 31 00 00 00 00
> |......XX XXX....|
> 0050 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0060 00 00 00 00 06 33 37 38-37 36 00 00 00 00 00 00
> |.....378 76......|
> 0070 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0080 00 00 00 05 03 01 06 0a-09 01 00 00 00 00 02 00
> |........ ........|
> 0090 00 00 00 00 54 53 51 4c-00 00 00 00 00 00 00 00
> |....TSQL ........|
> 00a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 00b0 00 00 04 31 39 32 2e 31-36 38 2e 32 35 34 2e 32
> |...192.1 68.254.2|
> 00c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 00d0 00 0d 7a 69 6d 62 61 31-00 00 00 00 00 00 00 00
> |..XXXXX........|
> 00e0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 00f0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0100 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0110 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0120 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0130 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0140 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0150 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0160 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0170 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0180 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 0190 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 01a0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 01b0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 01c0 00 00 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |........ ........|
> 01d0 00 06 04 02 00 00 54 44-53 2d 4c 69 62 72 61 72
> |......TD S-Librar|
> 01e0 0a 00 00 00 00 00 0d 11-75 73 5f 65 6e 67 6c 69
> |........ us_engli|
> 01f0 73 68 00 00 00 00 00 00-00 00 00 00 00 00 00 00
> |sh...... ........|
> 
> 
> Sending packet @ 10:28:03.230661
> 0000 02 01 00 4c 00 00 00 00-00 00 00 00 00 00 0a 00
> |...L.... ........|
> 0010 00 00 00 00 00 00 00 00-00 00 00 00 00 69 73 6f
> |........ .....iso|
> 0020 36 34 36 00 00 00 00 00-00 00 00 00 00 00 00 00
> |646..... ........|
> 0030 00 00 00 00 00 00 00 00-00 00 00 06 01 35 31 32
> |........ .....512|
> 0040 00 00 00 03 00 00 00 00-00 00 00 00            
> |........ ....|
> 
> 
> 10:28:03.230800 tds_process_login_tokens()
> 10:29:09.774652 tds_client_msg: #20004: "Read from SQL
> server failed.".  Connect
> ion state is now 0.
> 10:29:09.774798 looking for login token, got  0()
> 10:29:09.774834 tds_process_default_tokens() marker is
> 0()
> 10:29:09.774863 leaving tds_process_default_tokens()
> connection dead
> 10:29:09.774909 tds_client_msg: #20014: "Login
> incorrect.".  Connection state is
>  now 4.
> 
> 
> =====
> Honner Consulting, LLC 
> 818 Forestdale Road
> Royal Oak, MI 48067
> 248-506-1020 
> mike AT honner.com
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds