Trouble connecting from redhat to sql server
Ben Vogan <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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