Re: Windows authentication / login with local user
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4cVKm_x9XFYQdPq7cUAoQVjZccu6wQCBsLAf6Xe4CJP+A@mail.gmail.com> |
2011/11/17 <[email protected]>: > 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