Skip to Content.
Sympa Menu

freetds - [freetds] FreeTDS and SQL Server using NT Authentication

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Tony Bibbs <tony AT tonybibbs.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] FreeTDS and SQL Server using NT Authentication
  • Date: Thu, 25 Sep 2003 15:08:57 -0500

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





Archive powered by MHonArc 2.6.24.

Top of Page