Skip to Content.
Sympa Menu

freetds - RE: [freetds] Problem connecting to SQL Server 8.0 and XP Professional

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Danny Raetzsch" <danny AT msc.tamu.edu>
  • To: <fishtail100-freetds AT yahoo.com>, "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Cc:
  • Subject: RE: [freetds] Problem connecting to SQL Server 8.0 and XP Professional
  • Date: Tue, 19 Oct 2004 18:21:09 -0500

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?

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




Archive powered by MHonArc 2.6.24.

Top of Page