Skip to Content.
Sympa Menu

freetds - Re: [freetds] Login failed

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Robert Young" <ryoung AT medicalpharmacies.com>
  • To: "'Randy Syring'" <rsyring AT inteli-com.com>
  • Cc: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Login failed
  • Date: Tue, 12 Apr 2011 15:30:52 -0400

I can log into the Windows server using mu domain credentials and then start
the Management Studio without any problem. Is it possible that I need to
change the connection info to get to the database?

-----Original Message-----
From: Randy Syring [mailto:randy AT rcs-comp.com] On Behalf Of Randy Syring
Sent: April-12-11 3:20 PM
To: Robert Young
Cc: freetds AT lists.ibiblio.org
Subject: Re: [freetds] Login failed

Robert,

Please "reply-all" so the group gets the response and dump file. :)

I don't see anything obvious. Can you connect using SQL mode from
another machine with something like SQL Management Studio?

--------------------------------------
Randy Syring
Intelicom
Direct: 502-276-0459
Office: 502-212-9913

For the wages of sin is death, but the
free gift of God is eternal life in
Christ Jesus our Lord (Rom 6:23)


On 04/12/2011 03:01 PM, Robert Young wrote:
>
> -----Original Message-----
> From: Randy Syring [mailto:randy AT rcs-comp.com] On Behalf Of Randy Syring
> Sent: April-12-11 2:52 PM
> To: FreeTDS Development Group
> Cc: Robert Young
> Subject: Re: [freetds] Login failed
>
> Robert,
>
> Can you try `TDSDUMPCONFIG=config-dump.log tsql ...` and attach that log
> file. It has helpful info on what params are being used to connect.
>
> --------------------------------------
> Randy Syring
> Intelicom
> Direct: 502-276-0459
> Office: 502-212-9913
>
> For the wages of sin is death, but the
> free gift of God is eternal life in
> Christ Jesus our Lord (Rom 6:23)
>
>
> On 04/12/2011 02:45 PM, Robert Young wrote:
>> I tried compiling '--with-openssl' just in case but I get tjhe same
>> results.
>> I know I can log in to the server using my domain credential with the
>> Remote
>> Desktop Connection wizard. The server is running Windows Server 2008 R2.
>>
>> -----Original Message-----
>> From: freetds-bounces AT lists.ibiblio.org
>> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Ken Collins
>> Sent: April-12-11 10:13 AM
>> To: FreeTDS Development Group
>> Subject: Re: [freetds] Login failed
>>
>>
>> I've seen EOF's on TDS type mismatches. So make sure to have "tds version =
>> 8.0" or "tds version = 7.1" (if 0.91) in your conf file? Just a thought.
>>
>> - Ken
>>
>>
>> On Apr 12, 2011, at 10:03 AM, jklowden AT schemamania.org wrote:
>>
>>> On Tue, Apr 12, 2011 at 09:19:58AM -0400, Robert Young wrote:
>>>> tsql -S kcrsreport -U acct_dom1\roberty
>>> ...
>>>> Error 20017 (severity 9):
>>>> Unexpected EOF from the server
>>>> Error 20002 (severity 9):
>>>> Adaptive Server connection failed
>>>> There was a problem connecting to the server
>>> Not to belabor the obvious, but you would need to quote that backslash:
>>>
>>> tsql -S kcrsreport -U 'acct_dom1\roberty'
>>> or
>>> tsql -S kcrsreport -U acct_dom1\\roberty
>>>
>>> But normally that would result in simple "login failed" message, not
>>> an unepxected EOF from the server.
>>>
>>> HTH.
>>> --jkl
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>> _______________________________________________
>> 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