Skip to Content.
Sympa Menu

freetds - Re: [freetds] is the server there?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] is the server there?
  • Date: Tue, 16 Oct 2012 11:35:40 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page