Skip to Content.
Sympa Menu

freetds - Re: [freetds] Login failed

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: David Dick <ddick AT cpan.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Login failed
  • Date: Tue, 12 Apr 2011 07:54:36 +1000

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





Archive powered by MHonArc 2.6.24.

Top of Page