[freetds] How to connect via windows authentication?

Velichko Yuriy velichko.yuriy at gmail.com
Fri Mar 13 11:03:31 EDT 2015


The first approach works fine. I saw it before but forgot to duplicate '\'
symbol in the user name, so got an error, very shamefully. )

Second approach needs more time to realisation but I'm sure that I can
implement it too.

Thanks for the quick answer. Very helpful.

On 13 March 2015 at 16:46, Frediano Ziglio <freddy77 at gmail.com> wrote:

> 2015-03-13 14:09 GMT+00:00 Velichko Yuriy <velichko.yuriy at gmail.com>:
> > Hello!
> >
> > I can't figure out how to connect to SQL Server via windows auth using
> > fretds library (dblib).
> >
> > In examples is shown how to connect via the SQL authentication.
> >
> > Is there example for windows auth.
> > Should I change conf file, or set specific info to the LOGINREC for
> > dbopen() ?
> Hi,
>   there are two way. Use domain username/password or use single sign on.
> To use domain username/password just specify the domain in your
> username. Something like "DOMAIN_NAME\\user_name" with your domain
> password. Could be that you have to use ntlm version 2 (see
> documentation).
> The other option is to use Kerberos or on Windows SSPI. The trick is
> to specify empty strings for username and password. SSPI is used (and
> available) on Windows and will use your logged on user while on any
> other machine you have to setup Kerberos and login (kinit usually)
> before launching your dblib application.
> Regards,
>    Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

​С уважением, Величко Юрий.

More information about the FreeTDS mailing list