FreeTDS Development Group

[Tony Bibbs <tony AT tonybibbs.com>]

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                  |
+----------------------------------------------------------------------+