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