FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Jay Sauls [mailto:jaysauls AT hotmail.com]
> Sent: October 4, 2002 1:52 AM
> 
> I think I do have my freetds.conf configured correctly; I can run
> 
> tsql -S <my.machine.name> -U <mydomain\\myuser>
> 
> and it works perfectly (against a sql server configured for 
> only integrated auth).

Jay, 

You're at the edge of what I know about this, so I'm not going to be much
help.  FWIW, I think you might be the first guy to use FreeTDS's ct-lib to
connect to Microsoft's server using a domain login.  The ride may be a
little bumpy.  :/  This we know for sure: it's not what Scott Gray had in
mind when he started sqsh!  

If I were trying to do what you're doing, I'd turn on logging.  I'd connect
with tsql, exit, and attempt with sqsh.  Post both logs here.  Frediano or
Brian or Steve would be the ones to look at the log and possibly tell you
what's going on.  It could be something silly, you know, like sqsh getting
surprised by the backslash.  

(Memo to file.  We should support samba-style //domain/login as well as
\\domain\login.)

There's an Ethereal whatchamcallit for TDS; I don't know if that would be
any use to you.  

Be aware that your password will be in the logs.  

I don't think you're far away from getting this to work, but you might wind
up needing the latest FreeTDS snapshot, if a fix is required.  

Regards, 

--jkl



> >Not OT at all, Jay, a FreeTDS question.  There might be some 
> details (or
> >bugs), but what you're doing should work.
> >
> >sqsh works with any flavor of the TDS protocol or server.  
> No limitation
> >there.  Also you don't need -X because all the domain login 
> work is done
> >by FreeTDS (and associated libraries).
> >
> >I suggest you try connecting with tsql first, to make sure 
> you have your
> >freetds.conf set up correctly.  If tsql works and sqsh 
> doesn't, we'll have
> >some serious troubleshooting to do.
> >
> >It's important that $SYBASE was set correctly when you 
> compiled and linked
> >sqsh, so that it finds the right FreeTDS libraries.


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that for certain accounts we do not accept
orders and/or instructions by e-mail, and for those accounts we will not be
responsible for carrying out such orders and/or instructions. Kindly refrain
from sending orders or instructions by e-mail unless you have confirmed that
we accept such communications for your account. Please also note that to
satisfy regulatory requirements we review the outgoing and incoming e-mail
correspondence of staff members serving certain functions.