[freetds] SQL Server 200, Windows Server 2003 and FreeTDS

Mark Larsen larsenmtl at gmail.com
Thu Aug 24 12:44:46 EDT 2006


List Members,

We've been using FreeTDS and unixODBC to talk to a SQL Server 2000 running
on a Windows Server 2000 for a long time now.  Recently the server was
migrated to server 2003.  Connections now fail with:

isql 'DNS' 'bdx\\MDMedTrans' 'password' -v
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[28000][unixODBC][FreeTDS][SQL Server]Login incorrect.
[][unixODBC][FreeTDS][SQL Server]Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection.
[ISQL]ERROR: Could not SQLConnect

I've tried what's described here
http://www.freetds.org/userguide/domains.htm#DOMAINDETAILS but this has no
effect.

We are using versions:
FreeTDS 0.62.3
unixODBC-2.2.6

The TDSDump is:

Starting log file for FreeTDS 0.62.3
        on 2006-08-24 12:38:14 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
12:38:14.593728 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
12:38:14.593790 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
12:38:14.593831 Connecting to 10.3.3.68 port 1433, TDS 8.0.
12:38:14.594175 tds_put_string converting 10 bytes of "mdrnd11910"
12:38:14.594223 tds_put_string wrote 20 bytes
12:38:14.594252 tds_put_string wrote 0 bytes
12:38:14.594275 tds_put_string converting 12 bytes of "NAMD00MED001"
12:38:14.594300 tds_put_string wrote 24 bytes
12:38:14.594323 tds_put_string wrote 0 bytes
12:38:14.594345 tds_put_string converting 10 bytes of "us_english"
12:38:14.594369 tds_put_string wrote 20 bytes
12:38:14.594392 tds_put_string converting 6 bytes of "DNS"
12:38:14.594416 tds_put_string wrote 12 bytes
12:38:14.594466 tds_process_login_tokens()
Received header @ 12:38:14.595137
0000 04 01 00 d8 00 00 01 00-                        |........|


Received packet @ 12:38:14.595183
0000 aa c4 00 14 48 00 00 01-0e 5c 00 4c 00 6f 00 67 |....H... .\.L.o.g|
0010 00 69 00 6e 00 20 00 66-00 61 00 69 00 6c 00 65 |.i.n. .f .a.i.l.e|
0020 00 64 00 20 00 66 00 6f-00 72 00 20 00 75 00 73 |.d. .f.o .r. .u.s|
0030 00 65 00 72 00 20 00 27-00 28 00 6e 00 75 00 6c |.e.r. .' .(.n.u.l|
0040 00 6c 00 29 00 27 00 2e-00 20 00 52 00 65 00 61 |.l.).'.. . .R.e.a|
0050 00 73 00 6f 00 6e 00 3a-00 20 00 4e 00 6f 00 74 |.s.o.n.: . .N.o.t|
0060 00 20 00 61 00 73 00 73-00 6f 00 63 00 69 00 61 |. .a.s.s .o.c.i.a|
0070 00 74 00 65 00 64 00 20-00 77 00 69 00 74 00 68 |.t.e.d.  .w.i.t.h|
0080 00 20 00 61 00 20 00 74-00 72 00 75 00 73 00 74 |. .a. .t .r.u.s.t|
0090 00 65 00 64 00 20 00 53-00 51 00 4c 00 20 00 53 |.e.d. .S .Q.L. .S|
00a0 00 65 00 72 00 76 00 65-00 72 00 20 00 63 00 6f |.e.r.v.e .r. .c.o|
00b0 00 6e 00 6e 00 65 00 63-00 74 00 69 00 6f 00 6e |.n.n.e.c .t.i.o.n|
00c0 00 2e 00 00 00 00 00 fd-02 00 00 00 00 00 00 00 |........ ........|


12:38:14.595331 looking for login token, got  aa(ERROR)
12:38:14.595358 tds_process_default_tokens() marker is aa(ERROR)
tds_get_string: reading 184 from wire to give 92 to client.
12:38:14.595424 looking for login token, got  fd(DONE)
12:38:14.595448 tds_process_default_tokens() marker is fd(DONE)
12:38:14.595473 tds_process_end: more_results = 0
                was_cancelled = 0
                error = 1
                done_count_valid = 0
12:38:14.595503 tds_process_end() state set to TDS_IDLE
12:38:14.595526 leaving tds_process_login_tokens() returning 0
12:38:14.595583 tds_client_msg: #20014: "Login incorrect.".  Connection
state is now 2.

Any ideas?

Thanks,

Mark



More information about the FreeTDS mailing list