Re: Login failed

I compiled the initial code on SCO Open Server 5.0.7. 0.91 wouldn't compile there because of library issue so I complied in on SCO Open Server 6.0.0.

My command line and result was:

tsql -S kcrsreport -U acct_dom1\roberty
Password:
locale is "C"
locale charset is ""
using default charset ""
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

Dump file attached.

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio
Sent: April-12-11 4:44 AM
To: FreeTDS Development Group
Subject: Re: [freetds] Login failed

I noted you are using 0.82 version. It could occur that your version
is not patched with post releases patches. Could you try 0.91rc1 ??

Frediano

2011/4/12 Robert Young <[email protected]>:
> Yes
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio
> Sent: April-12-11 4:17 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] Login failed
>
> Same user from error and dump ??
>
> 2011/4/12 Robert Young <[email protected]>:
>> Same result.
>>
>> -----Original Message-----
>> From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio
>> Sent: April-12-11 3:28 AM
>> To: FreeTDS Development Group
>> Subject: Re: [freetds] Login failed
>>
>> Have you used DOMAIN\user syntax in -U argument ??
>>
>> freddy77
>>
>> 2011/4/12 Robert Young <[email protected]>:
>>> I had already performed the telnet check. That was OK. I ran the tsql again
>>> with a basic dump file (attached).
>>>
>>> -----Original Message-----
>>> From: [email protected]
>>> [mailto:[email protected]] On Behalf Of David Dick
>>> Sent: April-11-11 5:55 PM
>>> To: FreeTDS Development Group
>>> Subject: Re: [freetds] Login failed
>>>
>>> On 11/04/11 23:56, Robert Young wrote:
>>>> I've set up the latest version for 7.0 and the SQL Server is set up for
>>>> Mixed Mode Authentication. I can log in to the SQL Server using my domain
>>>> credentials but the following happens when I try to use tsql to connect:
>>>>
>>>> tsql -H myhost -p 1433 -U user
>>>>
>>>
>>> Hi Robert,
>>>
>>> A couple of things you might find useful.
>>>
>>> 1) Try "telnet myhost 1433".  If this command fails to connect, there is
>>> nothing that freetds can do.  You will need to talk to the administrator
>>> of the machine and specifically enable tcp/ip communications for SQL Server.
>>>
>>> 2) If "telnet myhost 1433" does connect, see
>>> http://www.freetds.org/userguide/logging.htm for how to set the TDSDUMP
>>> environment variable and then run your tsql command again.  The file
>>> designated by TDSDUMP will contain a debug account of the connection.
>>> If you wish to post this to the list for further analysis, beware that
>>> the debug log will contain your username and password in clear and
>>> encoded form.
>>>
>>> Cheers
>>> David
>>>
>>> _______________________________________________
>>> FreeTDS mailing list
>>> [email protected]
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>
>>> _______________________________________________
>>> FreeTDS mailing list
>>> [email protected]
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>
>>>
>> _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>>
>> _______________________________________________
>> FreeTDS mailing list
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds

log.c:196:Starting log file for FreeTDS 0.91.dev.20110409RC1
	on 2011-04-12 09:13:44 with debug flags 0x4fff.
net.c:205:Connecting to 192.168.200.5 port 1433 (TDS version 7.0)
net.c:270:tds_open_socket: connect(2) returned "Operation now in progress"
net.c:310:tds_open_socket() succeeded
util.c:156:Changed query state from DEAD to IDLE
login.c:776:quietly sending TDS 7+ login packet
token.c:328:tds_process_login_tokens()
util.c:331:tdserror(8085118, 80852b0, 20017, 0)
util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:384:tdserror: returning TDS_INT_CANCEL(2)
util.c:156:Changed query state from IDLE to DEAD
token.c:337:looking for login token, got  0()
token.c:122:tds_process_default_tokens() marker is 0()
token.c:125:leaving tds_process_default_tokens() connection dead
login.c:460:login packet accepted
util.c:331:tdserror(8085118, 80852b0, 20002, 0)
util.c:361:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:384:tdserror: returning TDS_INT_CANCEL(2)
mem.c:615:tds_free_all_results()