Re: Integrated Windows Authentication
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Mon, 21 Mar 2011 23:12:34 +0000 "Korosi, Nick" <[email protected]> wrote: > I was wondering if it's possible pass the current users credentials to Microsoft SQL Server using integrated authentication so that the user doesn't have to type in their password in clear text. I have Samba/Winbind installed and the Linux server is a member of the domain. The user is logging into the shell with their domain username and password as well. http://freetds.schemamania.org/91/userguide/kerberos.htm http://freetds.schemamania.org/91/userguide/config.htm#EVERYONE Yes. All you need is Kerberos: 1. Kerberos has use Active Directory 2. kinit(1) and sclient(1) should work 3. FreeTDS is configured with --enable-krb5 4. you've linked in the Kerberos libraries then it should Just Work. The utilities in the current snapshot don't even require -U and -P; they attempt a Kerberos/SSPI login if no username is provided. --jkl