FreeTDS Development Group

[majid AT enoor.com]

I should have mentioned it last time, but I am trying to connect using
tsql.
I tried setting try server login = yes (although, it is the default) but
still no luck logging on.  
here is the error message from tsql:


Msg 18456, Level 14, State 1, Server , Line 0
Login failed for user 'web_admin'.
Msg 20004, Level 9, State 0, Server OpenClient, Line 0
Read from SQL server failed.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

Lowden, James K writes:

> > From: majid AT enoor.com [mailto:majid AT enoor.com]
> > Sent: July 24, 2003 12:20 PM
> > 
> > I seem to have a problem connecting to MSSQL Server on 
> > windows 2000.  I am
> > on Redhat 8.0 and I am using freetds version .61.  The message that is
> > displayed is "There was a problem connecting to the server"
> 
> Your application isn't displaying a very good error message.  :-(
> 
> As you can see from the first packet in the log file (thanks for sending it)
> , the error message is:
> 
> Login failed for user 'web_admin'
> 
> Try logging in as 'web_admin' using tsql.  You might want to change these
> settings in freetds.conf:
> 
>       try domain login = yes
> and
>       try server login = no
> 
> One (and only one) of them should be set to "yes".  The default is "try
> server login = yes".  
> 
> HTH.  
> 
> --jkl
> 
> > Starting log file with debug level 99.
> > 2003-07-24 12:09:52.820621 iconv will convert client-side 
> > data to the ""
> > character set
> > 2003-07-24 12:09:52.821004 Connecting addr 216.89.220.17 port 
> > 1433 with TDS
> > version 7.0
> > 2003-07-24 12:09:52.821581 inside tds_process_login_tokens()
> > Received header @ 2003-07-24 12:09:52.821928
> > 0000  04 01 00 64 00 00 00 00                            |...d....|
> > 
> > 
> > Received packet @ 2003-07-24 12:09:52.821998
> > 0000  aa 50 00 18 48 00 00 01  0e 22 00 4c 00 6f 00 67   |.P..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 77 00 65 00 62 00 5f   |.e.r. .'
> > .w.e.b._|
> > 0040  00 61 00 64 00 6d 00 69  00 6e 00 27 00 2e 00 00   |.a.d.m.i
> > .n.'....|
> > 0050  00 00 00 fd 02 00 00 00  00 00 00 00               
> > |........ ....|
> > 
> > 
> > 2003-07-24 12:09:52.822132 inside 
> > tds_process_default_tokens() marker is
> > aa(ERROR)
> > 2003-07-24 12:09:52.835112 inside 
> > tds_process_default_tokens() marker is
> > fd(DONE)
> > 2003-07-24 12:09:52.835236 inside tds_process_end() more_results = 0,
> > was_cancelled = 0 
> > 2003-07-24 12:09:52.835269 inside tds_process_default_tokens() setting
> > state to COMPLETED
> > Sending packet @ 2003-07-24 12:09:52.835345
> > 0000  01 01 00 22 00 00 01 00  73 00 65 00 6c 00 65 00   |..."....
> > s.e.l.e.|
> > 0010  63 00 74 00 20 00 40 00  40 00 73 00 70 00 69 00   |c.t. .@.
> > @.s.p.i.|
> > 0020  64 00                                              |d.|
> > 
> > 
> > 2003-07-24 12:09:52.836149 processing result tokens.  marker is  0()
> > 2003-07-24 12:09:52.836240 inside 
> > tds_process_default_tokens() marker is
> > 0()
> > 2003-07-24 12:09:52.836270 leaving 
> > tds_process_default_tokens() connection
> > dead
> > 2003-07-24 12:09:52.836298 tds_set_spid() failed
> > 2003-07-24 12:09:52.836321 leaving tds_process_login_tokens() 
> > returning 0
> > 
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > 
> -----------------------------------------
> The information contained in this transmission may contain privileged and 
> confidential information and is intended only for the use of the person(s) 
> named above. If you are not the intended recipient, or an employee or agent 
> responsible for delivering this message to the intended recipient, any 
> review, dissemination, distribution or duplication of this communication is 
> strictly prohibited. If you are not the intended recipient, please contact 
> the sender immediately by reply e-mail and destroy all copies of the 
> original message. Please note that we do not accept account orders and/or 
> instructions by e-mail, and therefore will not be responsible for carrying 
> out such orders and/or instructions.
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds