FreeTDS Development Group

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

I had already performed the telnet check. That was OK. I ran the tsql again
with a basic dump file (attached).

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] 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
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

Attachment: tdsdump.log
Description: Binary data