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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.