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