Skip to Content.
Sympa Menu

freetds - Re: [freetds] Can't Connect

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: majid AT enoor.com
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Can't Connect
  • Date: Thu, 24 Jul 2003 17:51:02 GMT


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







Archive powered by MHonArc 2.6.24.

Top of Page