FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

On Tue, 16 Oct 2012 08:54:20 -0400
Evan Panagiotopoulos <epanagio AT gmail.com> wrote:

> 
> root@... > tsql -H 10.1.1.16 -p 1433 -U osdadmin
> locale is "C"
> locale charset is "US-ASCII"
> Password:
> Msg 18456, Level 14, State 1, Server KCSD-ZONE-INT, Line 1
> Login failed for user 'osdadmin'.

Message 18456 came from the server named "KCSD-ZONE-INT".  FreeTDS
transmitted the credentials you provided.  If the server says your login
failed, it failed.  :-(  

> root@... > tsql -S 10.1.1.16 -U osdadmin

The -S causes tsql to look in freetds.conf.  Unless you have an entry
like 
        [10.1.1.16]
        host = 10.1.1.16

tsql will not use freetds.conf settings to connect to the server.  It
may *connect* anyway, by converting (as a last-ditch effort) the string
to an address, but then likely as not it will fail to log in because
it won't use the right TDS version.  

--jkl