FreeTDS Development Group

["Robert Young" <ryoung AT medicalpharmacies.com>]

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
>>