[freetds] FreeTDS and SQL Server using NT Authentication

Tony Bibbs tony at tonybibbs.com
Thu Sep 25 16:08:57 EDT 2003


I have developed  PHP app for a client.  We developed the system 
in-house against our SQL server using SQL Server authentication.  The 
production machine is remote and using NT authentication.  I have 
verified connectivity by telneting to the remote SQL Server on the right 
port.

I think have something like this in freetds.conf:

[RemoteSQLServer]
	host = XXX.XXX.XXX.XXX (I have replaced this with actual IP)
	port = 1433
	tds version = 8.0
	try domain login = yes
	try server login = no

I then do:

#> ./tsql -SRemoteSQLServer -UsomeUserName -PsomePassword

and I get:

Msg 18452, Level 14, State 1, Server, Line 0
Login failed for user 'someUserName'. Reason: Not associated with a 
trusted SQL Server Connection
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login Incorrect.
There was a problem connecting to the server

Any suggestions as to how to get around this?

--Tony

+----------------------------------------------------------------------+
|Tony Bibbs         |[R]egardless of what you may think of our penal   |
|tony at tonybibbs.com |system, the fact is that every man in jail is one |
|                   |less potential fisherman to clutter up your       |
|                   |favorite pool or pond. --Ed Zern                  |
+----------------------------------------------------------------------+



More information about the FreeTDS mailing list