Re: FreeTDS and SQL Server using NT Authentication

Thanks John, I think I'll go down the road of trying to convince them to 
use SQL Server authentication since it is the path of least resistance. 
 I'll archive your note in case I lose that battle and have to start 
poking more firewall holes (sigh).

--Tony

Lowden, James K wrote:
> > From: Tony Bibbs [mailto:tony@xxxxxxxxxxxxx]
> > Sent: September 25, 2003 4:33 PM
> >
> > Hrm, that may explain our problems.  We *do* have a firewall 
> > between our 
> >  freetds machine and the NT PDC.  The FreeTDS box is one of 
> > ours, the SQL Server is on our client's network.
> >
> > We've already poked holes in the firewall for port 1433 between our 
> > FreeTDS server and the SQL Server, I'm assuming NT 
> > authentication will require additional ports?  
>
>
> Yes.  
>
>
> > If so which.
>
>
> Dunno offhand, sorry.  Start with:
>
> http://www.schemamania.org/projects/freetds/build/doc/userguide/x1382.htm
> and 
> http://davenport.sourceforge.net/ntlm.html
>
> Microsoft documents it, too.  See the SQL Server documentation, Samba docs,
> or, you know, google-is-your-friend.  
>
>
> > (Sigh) Sorry, I don't personally maintain any NT/2003 boxes so this 
> > wasn't immediately obvious to me.
>
>
> No worries.  HTH.
>
> --jkl
> -----------------------------------------
> 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 we do not accept account orders and/or instructions by e-mail, 
> and therefore will not be responsible for carrying out such orders and/or 
> instructions.
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS@xxxxxxxxxxxxxxxxx
> http://lists.ibiblio.org/mailman/listinfo/freetds

--
+----------------------------------------------------------------------+
|Tony Bibbs         |[R]egardless of what you may think of our penal   |
|tony@xxxxxxxxxxxxx |system, the fact is that every man in jail is one |
|                   |less potential fisherman to clutter up your       |
|                   |favorite pool or pond. --Ed Zern                  |
+----------------------------------------------------------------------+