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