Re: Login failed

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:[email protected]] On Behalf Of Randy Syring
Sent: April-12-11 3:20 PM
To: Robert Young
Cc: [email protected]
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:[email protected]] 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: [email protected]
>> [mailto:[email protected]] 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, [email protected] 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
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>> _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>