freetds.log message

Evan Panagiotopoulos <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAAMN46d7vkLVKq6WRz_cQLZ-XMt1nM2bOLOJkdGm9MwYkQZAxA@mail.gmail.com>
I keep working on debugging a connection to a ms sql server and I get the
following message in the log file:

net.c:542:Received packet
0000 aa 68 00 18 48 00 00 01-0e 21 00 4c 00 6f 00 67 |.h..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 6f 00 73 00 64 00 61 |.e.r. .' .o.s.d.a|
0040 00 64 00 6d 00 69 00 6e-00 27 00 2e 00 0d 4b 00 |.d.m.i.n .'....K.|
0050 43 00 53 00 44 00 2d 00-5a 00 4f 00 4e 00 45 00 |C.S.D.-. Z.O.N.E.|
0060 2d 00 49 00 4e 00 54 00-00 01 00 fd 02 00 00 00 |-.I.N.T. ........|
0070 00 00 00 00            -                        |....|

The above is teling me that the user id failed to connect.
I am trying to understand what the following means, though.

token.c:314:looking for login token, got  aa(ERROR)
token.c:105:tds_process_default_tokens() marker is aa(ERROR)
token.c:2439:tds_process_msg() reading message from server
read.c:179:tds_get_string: reading 66 from wire to give 33 to client.
read.c:179:tds_get_string: reading 26 from wire to give 13 to client.
token.c:2501:tds_process_msg() calling client msg handler

We test the user id and password on the ms sql server and we have no
problem connecting but when I try to connect from a freebsd server I
receive the above messages. The php log file says:
mssql_connect(): message: Login failed for user 'osdadmin'. (severity 14)
in /home/epanagio/play/remote_connect.php on line 3
mssql_connect(): Unable to connect to server: kcsd-zone-int in
/home/epanagio/play/remote_connect.php on line 3

I also tried other versions of the php script including the port, without
the port, with the server name, the ip address but none of those got me
connected.

Any suggestions?

-- 
Evan Panagiotopoulos
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.