[unixODBC-support] domain login fails in isql but works with tsql

Eric Robinson (erirobin) erirobin at cisco.com
Thu Apr 15 03:45:30 BST 2010


Hi, when trying to connect from Linux to MSSQL Server 2005 via isql my
connection fails using a NT Domain account.  

 

Should isql work with a domain account? If so what is the proper setup?

 

I have verified TDFREE drivers are working properly by connecting via
tsql using the domain account.

 

Working:  tsql -S <tsfree.conf entry>  -p 1433 -U <domain>\\<userid
<file:///\\%3cuserid> >

 

I believe most of the setup is correct as I can see the login attempt on
the proper server:database but it does not appear to parse the
domain\userid properly.

 

Not working : isql -v <odbc.ini entry>   <domain>\\<userid
<file:///\\%3cuserid> >

 

Linux side error msg:

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source

[37000][unixODBC][FreeTDS][SQL Server]Login failed for user ''. The user
is not associated with a trusted SQL Server connection.

 

Sqlserver 2005 side error message:

 

04/14/2010 22:18:38,Logon,Unknown,Login failed for user ''. The user is
not associated with a trusted SQL Server connection. [CLIENT:
10.81.247.6]

04/14/2010 22:18:38,Logon,Unknown,Error: 18452<c/> Severity: 14<c/>
State: 1.

04/14/2010 22:18:38,Logon,Unknown,SSPI handshake failed with error code
0x8009030c while establishing a connection with integrated security; the
connection has been closed. [CLIENT: 10.81.247.6]

04/14/2010 22:18:38,Logon,Unknown,Error: 17806<c/> Severity: 20<c/>
State: 2.

 

Thanks, Eric

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20100414/21c681b4/attachment.html>


More information about the unixODBC-support mailing list