Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ruh90 AT gmx.de
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Windows authentication / login with local user
  • Date: Thu, 17 Nov 2011 12:25:15 +0100

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
--
NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!

Jetzt informieren: http://www.gmx.net/de/go/freephone




Archive powered by MHonArc 2.6.24.

Top of Page