Skip to Content.
Sympa Menu

freetds - [freetds] Trouble connecting from redhat to sql server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Ben Vogan <benvogan AT hotmail.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Trouble connecting from redhat to sql server
  • Date: Sat, 5 Jun 2010 13:28:30 -0600


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



Archive powered by MHonArc 2.6.24.

Top of Page