Skip to Content.
Sympa Menu

freetds - Re: [freetds] Windows authentication / login with local user

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Windows authentication / login with local user
  • Date: Thu, 17 Nov 2011 16:10:15 +0100

2011/11/17 <ruh90 AT gmx.de>:
> Hello list,
>
> i have a question regarding the documentation on
> http://www.freetds.org/userguide/domains.htm
>
> "To use domain logins without SSPI or Kerberos, use the 'DOMAIN\username'
> syntax for the username and use the domain password."
>
> The database server i want to connect to is not a member of a Windows
> Domain. Instead, I want to use a local Windows User to use for
> authentication:
>
> tsql -S mssqlserver -U 'SERVER\mylocuser' -P password
>
> On the windows server i am getting the following errors:
>
> SSPI handshake failed with error code 0x80090311 while establishing a
> connection with integrated security; the connection has been closed.
>
> Login failed for user ''. The user is not associated with a trusted SQL
> Server connection. [CLIENT: 192.168.X.xx]
>
> What am I doing wrong?
>
> Thanks,
> Simon

You can try adding

use ntlmv2 = yes

line to your freetds.conf file.

Which server operating system are you using ?

Regards
Frediano Ziglio




Archive powered by MHonArc 2.6.24.

Top of Page