Re: Login failed
"Robert Young" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <000001cbf8a6$51b3ab60$f51b0220$@com> |
I had already performed the telnet check. That was OK. I ran the tsql again with a basic dump file (attached). -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of David Dick Sent: April-11-11 5:55 PM To: FreeTDS Development Group Subject: Re: [freetds] Login failed On 11/04/11 23:56, Robert Young wrote: > I've set up the latest version for 7.0 and the SQL Server is set up for > Mixed Mode Authentication. I can log in to the SQL Server using my domain > credentials but the following happens when I try to use tsql to connect: > > tsql -H myhost -p 1433 -U user > Hi Robert, A couple of things you might find useful. 1) Try "telnet myhost 1433". If this command fails to connect, there is nothing that freetds can do. You will need to talk to the administrator of the machine and specifically enable tcp/ip communications for SQL Server. 2) If "telnet myhost 1433" does connect, see http://www.freetds.org/userguide/logging.htm for how to set the TDSDUMP environment variable and then run your tsql command again. The file designated by TDSDUMP will contain a debug account of the connection. If you wish to post this to the list for further analysis, beware that the debug log will contain your username and password in clear and encoded form. Cheers David _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds
tdsdump.log
(application/octet-stream, 2.3 KB)
log.c:190:Starting log file for FreeTDS 0.82 on 2011-04-11 20:07:55 with debug flags 0x4fff. iconv.c:197:names for ISO-8859-1: ISO-8859-1 iconv.c:197:names for UTF-8: UTF-8 iconv.c:197:names for UCS-2LE: UCS-2LE iconv.c:197:names for UCS-2BE: UCS-2BE iconv.c:363:iconv to convert client-side data to the "ISO-8859-1" character set iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE" iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE" net.c:210:Connecting to 192.168.200.5 port 1433 (TDS version 7.0) net.c:264:tds_open_socket: connect(2) returned "Operation now in progress" net.c:303:tds_open_socket() succeeded util.c:162:Changed query state from DEAD to IDLE login.c:735:quietly sending TDS 7+ login packet token.c:312:tds_process_login_tokens() net.c:592:Received header 0000 04 01 00 74 00 3c 01 00- |...t.<..| net.c:671:Received packet 0000 aa 60 00 18 48 00 00 01-0e 20 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 72 00 6f 00 62 00 65 |.e.r. .' .r.o.b.e| 0040 00 72 00 74 00 79 00 27-00 2e 00 0a 4d 00 50 00 |.r.t.y.' ....M.P.| 0050 47 00 2d 00 52 00 45 00-50 00 4f 00 52 00 54 00 |G.-.R.E. P.O.R.T.| 0060 00 01 00 fd 02 00 00 00-00 00 00 00 |........ ....| token.c:316:looking for login token, got aa(ERROR) token.c:108:tds_process_default_tokens() marker is aa(ERROR) token.c:2451:tds_process_msg() reading message from server token.c:2516:tds_process_msg() calling client msg handler token.c:2529:tds_process_msg() returning TDS_SUCCEED token.c:316:looking for login token, got fd(DONE) token.c:108:tds_process_default_tokens() marker is fd(DONE) token.c:2201:tds_process_end: more_results = 0 was_cancelled = 0 error = 1 done_count_valid = 0 token.c:2217:tds_process_end() state set to TDS_IDLE token.c:2232: rows_affected = 0 token.c:393:leaving tds_process_login_tokens() returning 0 util.c:162:Changed query state from IDLE to DEAD util.c:334:tdserror(807c504, 807cd28, 20002, 0) util.c:368:tdserror: client library returned TDS_INT_CANCEL(2) util.c:389:tdserror: returning TDS_INT_CANCEL(2) mem.c:563:tds_free_all_results()