Re: is the server there?
"James K. Lowden" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
On Tue, 16 Oct 2012 08:54:20 -0400 Evan Panagiotopoulos <[email protected]> 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