Hello Friends,

I am wondering if it possible to use FreeTDS to talk from my RedHat 7.1 linux box to my MSSQL 7.0 server on a Win 2000 box using NT authentication. The rather sketchy documentation on the FreeTDS site seems to indicate that this is not possible, but others have suggested it might be. enoch suggested that I make the linux box a SAMBA server as well, and that would give it "NT credentials," although this does not appear to be working for me (SAMBA is, SQL connection not). This rather old node (14629) as well as this one (85813) and a few others address linux<->MSSQL connectivity, but none mention using NT authentication.

So, I am wondering what my options are now. I was hoping to use FreeTDS at least as a test case to show that this type of thing is possible and useful. I wanted to use FreeTDS because I didn't want to spend money on expensive software as a test case, even though I realize I may need to "upgrade" at some point. My sysadmin is not thrilled with the idea of using SQL authentication, but if that is my only choice, I may be able to talk him in to it.

As a side note, I would like to also use this node to publicly thank enoch for his considerable help on this project. A mutual friend mentioned to him that I was having difficulty on this project and he spent an entire afternoon working on a demo system so he could give me some pretty detailed instructions. Unfortunately, he does not use NT authentication, so he couldn't get me passed this last step. Nevertheless, enoch++.

Thanks for your attention,
Scott