[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