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

In reply to Linux-MSSQL with FreeTDS & NT auth by scain

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.