Skip to Content.
Sympa Menu

freetds - Re: [freetds] Login failed

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Robert Young" <ryoung AT medicalpharmacies.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Login failed
  • Date: Mon, 11 Apr 2011 20:12:31 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page