[freetds] Cannot connect to SQL6.5 with tsql

Eric Augustus gaugustu at cisco.com
Thu Dec 19 13:11:08 EST 2002


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
-------------- next part --------------
[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

-------------- next part --------------
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


More information about the FreeTDS mailing list