freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Cannot connect to SQL6.5 with tsql

From: Eric Augustus <gaugustu AT cisco.com>
To: FreeTDS mailing list <freetds AT lists.ibiblio.org>
Subject: [freetds] Cannot connect to SQL6.5 with tsql
Date: Thu, 19 Dec 2002 13:11:08 -0600

While testing the CVS snapshot from 12/16/02 on several of my test MSSQL
servers, I came across a login problem with MSSQL 6.5. I cannot get tsql
to login to my test SQL 6.5 server. It works fine against my SQL7 and
SQL2k servers; both with sa[no password] accounts.

Here's the command line used:

$> tsql -H 10.89.144.208 -p 1433 -U sa -P ""
locale is "C"
using default charset "iso_1"
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

I've tested this server against the 0.60 release without any problems.

Attached is the freetds.conf I used, which is the default.
Also, I've attached a tdsdump log file.

BTW, freetds was built using the following configure command:
$> ./configure --with-tdsver=7.0 --prefix=/opt/freetds

Any ideas?

--
----------------------------------------------------------
Eric P. Augustus | gaugustu AT cisco.com
Network Security Engineer | www.cisco.com
Cisco Systems Inc. | Voice: 512.378.1051
12515 Research Blvd. | Fax: 512.378.1425
Austin, Texas 78759-2220 | Pager: 800.365.4578
----------------------------------------------------------
It's not enough to be Hungarian; you must have talent too.
-- Alexander Korda
[global]
tds version = 4.2

initial block size = 512

swap broken dates = no

swap broken money = no

try server login = yes
try domain login = no

; nt domain = WORKGROUP

cross domain login = no

; dump file = /tmp/freetds.log
; debug level = 10

; timeout = 10
; connect timeout = 10

text size = 64512

[JDBC]
host = 192.138.151.39
port = 4444
tds version = 5.0

[JDBC_42]
host = 192.138.151.39
port = 4444
tds version = 4.2

[mypool]
host = 127.0.0.1
port = 5000
tds version = 4.2

;[MyServer70]
; host = ntmachine.domain.com
; port = 1433
; tds version = 7.0

;[MyServer70]
; host = ntmachine.domain.com
; port = 1433
; tds version = 7.0
; try domain login = yes
; try server login = no
; nt domain = MYDOMAIN

[MyServer65]
host = 10.89.144.208
port = 1433
tds version = 4.2

Starting log file with debug level 99.
2002-12-19 12:44:14.096538 Connecting addr 10.89.144.208 port 1433 with TDS
version 4.2
Sending packet @ 2002-12-19 12:44:14.097296
0000 02 00 02 00 00 00 00 00 63 68 6d 65 65 65 2d 6c |........ chmeee-l|
0010 69 6e 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |in...... ........|
0020 00 00 00 00 00 00 0a 73 61 00 00 00 00 00 00 00 |.......s a.......|
0030 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0040 00 00 00 00 00 02 00 00 00 00 00 00 00 00 00 00 |........ ........|
0050 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
0060 00 00 00 00 00 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 30 2e 38 39 2e 31 34 34 2e 32 30 38 |...10.89 .144.208|
00c0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
00d0 00 0d 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |........ ........|
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 00 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 @ 2002-12-19 12:44:14.097769
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 5f 31 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |_1...... ........|
0030 00 00 00 00 00 00 00 00 00 00 00 05 01 35 31 32 |........ .....512|
0040 00 00 00 03 00 00 00 00 00 00 00 00 |........ ....|

2002-12-19 12:44:14.097854 inside tds_process_login_tokens()
Received header @ 2002-12-19 12:44:14.183613
0000 04 01 00 84 00 00 00 00 |........|

Received packet @ 2002-12-19 12:44:14.183707
0000 e3 0f 00 01 06 6d 61 73 74 65 72 06 6d 61 73 74 |.....mas ter.mast|
0010 65 72 ab 31 00 45 16 00 00 02 00 25 00 43 68 61 |er.1.E.. ...%.Cha|
0020 6e 67 65 64 20 64 61 74 61 62 61 73 65 20 63 6f |nged dat abase co|
0030 6e 74 65 78 74 20 74 6f 20 27 6d 61 73 74 65 72 |ntext to 'master|
0040 27 2e 00 00 00 00 ad 1e 00 01 04 02 00 00 14 4d |'....... .......M|
0050 69 63 72 6f 73 6f 66 74 20 53 51 4c 20 53 65 72 |icrosoft SQL Ser|
0060 76 65 72 5f 06 32 ff e3 09 00 04 03 35 31 32 03 |ver_.2.. ....512.|
0070 35 31 32 fd 00 00 00 00 00 00 00 00 |512..... ....|

2002-12-19 12:44:14.183814 inside tds_process_default_tokens() marker is e3
2002-12-19 12:44:14.183866 inside tds_process_default_tokens() marker is ab
2002-12-19 12:44:14.183907 inside tds_process_default_tokens() marker is e3
2002-12-19 12:44:14.183999 inside tds_process_default_tokens() marker is fd
2002-12-19 12:44:14.184025 inside tds_process_end() more_results = 0,
was_cancelled = 0
2002-12-19 12:44:14.184050 inside tds_process_default_tokens() setting state
to COMPLETED
Sending packet @ 2002-12-19 12:44:14.184100
0000 01 01 00 15 00 00 00 00 73 65 6c 65 63 74 20 40 |........ select @|
0010 40 73 70 69 64 |@spid|

Received header @ 2002-12-19 12:44:14.185576
0000 04 01 00 22 00 00 00 00 |..."....|

Received packet @ 2002-12-19 12:44:14.185611
0000 a0 01 00 00 a1 06 00 06 00 00 00 26 02 d1 02 0d |........ ...&....|
0010 00 fd 10 00 c1 00 01 00 00 00 |........ ..|

2002-12-19 12:44:14.185650 processing result tokens. marker is a0
2002-12-19 12:44:14.185680 processing result tokens. marker is a1
2002-12-19 12:44:14.185713 processing result. type = 38(integer-null),
varint_size 1
2002-12-19 12:44:14.185741 tds_set_spid() failed
2002-12-19 12:44:14.185761 leaving tds_process_login_tokens() returning 0

[freetds] Cannot connect to SQL6.5 with tsql, Eric Augustus, 12/19/2002
- RE: [freetds] Cannot connect to SQL6.5 with tsql, Daniel Morgan, 12/19/2002
  - Re: [freetds] Cannot connect to SQL6.5 with tsql, Eric Augustus, 12/19/2002
- <Possible follow-up(s)>
- RE: [freetds] Cannot connect to SQL6.5 with tsql, ZIGLIO Frediano, 12/20/2002
  - Re: [freetds] Cannot connect to SQL6.5 with tsql, Eric Augustus, 12/20/2002