Re: Login failed
"Robert Young" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <017501cbf8ea$b090b3a0$11b21ae0$@com> |
Yes -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio Sent: April-12-11 4:17 AM To: FreeTDS Development Group Subject: Re: [freetds] Login failed Same user from error and dump ?? 2011/4/12 Robert Young <[email protected]>: > Same result. > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Frediano Ziglio > Sent: April-12-11 3:28 AM > To: FreeTDS Development Group > Subject: Re: [freetds] 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 > > > _______________________________________________ > FreeTDS mailing list > [email protected] > http://lists.ibiblio.org/mailman/listinfo/freetds > _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds