Re: Trouble connecting from redhat to sql server

Did you make sure to set the proper environment vars? That tripped me up
when I installed FreeTDS on both RH and Debian systems before.

On Sat, Jun 5, 2010 at 12:28 PM, Ben Vogan <[email protected]> wrote:

>
> Hi all,
> I am trying to debug a connection issue between my redhat server and SQL
> Server. I was hoping someone could let me know if the error below is related
> to authentication of the user or whether there is something wrong with my
> freetds configuration.
> $ ./tsql -S dbServer -U uuuu -D dddd -P xxxxlocale is "en_US.UTF-8"locale
> charset is "UTF-8"Default database being set to ddddMsg 18456, Level 14,
> State 1, Server WSP0APP131, Line 1Login failed for user 'uuuu'.Msg 20002,
> Level 9, State -1, Server OpenClient, Line -1Adaptive Server connection
> failedThere was a problem connecting to the server
> I get the same error if I use the -H option instead of trying to use the
> freetds.conf settings. I turned on debug logging and I see the following:
>
> 15:16:10.617695 22123 (login.c:1044):detected flag 215:16:10.617705 22123
> (login.c:771):quietly sending TDS 7+ login packet15:16:10.617741 22123
> (token.c:328):tds_process_login_tokens()15:16:10.621347 22123
> (net.c:608):Received header0000 04 01 00 78 00 48 01 00-
>    |...x.H..|
> 15:16:10.621368 22123 (net.c:662):Received packet[blanked for public
> consumption]
> 15:16:10.621422 22123 (token.c:337):looking for login token, got
>  aa(ERROR)15:16:10.621435 22123 (token.c:122):tds_process_default_tokens()
> marker is aa(ERROR)15:16:10.621446 22123 (token.c:2708):tds_process_msg()
> reading message 18456 from server15:16:10.621467 22123
> (token.c:2781):tds_process_msg() calling client msg handler15:16:10.621493
> 22123 (token.c:2794):tds_process_msg() returning TDS_SUCCEED15:16:10.621504
> 22123 (token.c:337):looking for login token, got  fd(DONE)15:16:10.621512
> 22123 (token.c:122):tds_process_default_tokens() marker is
> fd(DONE)15:16:10.621523 22123 (token.c:2459):tds_process_end: more_results =
> 0                was_cancelled = 0                error = 1
>  done_count_valid = 015:16:10.621532 22123 (token.c:2475):tds_process_end()
> state set to TDS_IDLE15:16:10.621540 22123 (token.c:2490):
>  rows_affected = 015:16:10.621549 22123
> (token.c:437):tds_process_login_tokens() returning TDS_FAIL15:16:10.621557
> 22123 (login.c:462):login packet accepted15:16:10.621575 22123
> (util.c:162):Changed query state from IDLE to DEAD15:16:10.621586 22123
> (util.c:337):tdserror(0x11ca9160, 0x11caa310, 20002, 0)15:16:10.621603 22123
> (util.c:367):tdserror: client library returned
> TDS_INT_CANCEL(2)15:16:10.621613 22123 (util.c:390):tdserror: returning
> TDS_INT_CANCEL(2)15:16:10.621621 22123 (mem.c:615):tds_free_all_results()
> Thanks for your help,--Ben
> _________________________________________________________________
> Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
> https://signup.live.com/signup.aspx?id=60969
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 
Robert Gonzalez
http://www.robert-gonzalez.com
http://twitter.com/RobertGonzalez
http://www.linkedin.com/in/robertanthonygonzalez