Skip to Content.
Sympa Menu

freetds - [freetds] Failing logins / instance ignored?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Matija Grabnar <matija.grabnar AT hermes-softlab.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Failing logins / instance ignored?
  • Date: Tue, 19 Dec 2006 14:05:42 +0100

I apologize if this is a FAQ, but I tried googling for it, looking through the mailing list, etc, and nothing seemed to help.

Here is what happens when I try to log in to a SQL server from Perl:

main::(../s/dbd.pl:13): my $dbh = DBI -> connect('dbi:Sybase:MSSQL:server=hsldbYukon;database=IT',
main::(../s/dbd.pl:14): 'itc','hidden')
main::(../s/dbd.pl:15): or die $DBI::errstr;
DB<1> n
FreeTDS: config.c:461: ignoring unrecognized option 'instance'
DBI connect('MSSQL:server=hsldbYukon;database=IT','itc',...) failed: Server message number=18456 severity=14 state=1 line=0 text=Login failed for user 'itc'.OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (46)
Message String: Login incorrect.
at ../s/dbd.pl line 13
at /usr/lib/perl5/DBI.pm line 638
DBI::__ANON__[/usr/lib/perl5/DBI.pm:687]('undef', 'undef') called at /usr/lib/perl5/DBI.pm line 689
DBI::connect('DBI', 'dbi:Sybase:MSSQL:server=hsldbYukon;database=IT', 'itc', 'hidden') called at ../s/dbd.pl line 13
Server message number=18456 severity=14 state=1 line=0 text=Login failed for user 'itc'.OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (46)
Message String: Login incorrect.
at ../s/dbd.pl line 13


So far I've ruled out having the wrong password (it is altered in the above messages, but many other people use the same username password combo to access that server, and I did double check it), some kind of IP related or firewall related problem on the server, and having an outdated installation of freetds (I get the same results with 0.63 and the stable and the current version, and the latest snapshot).

All the versions return the line which I think may be the clue:

FreeTDS: config.c:461: ignoring unrecognized option 'instance',
and CLOSE to line 461 in config.c I find the line that >>seems<< to be handling it.

NB: I found the instance parameter in freetds docs.

Doing the troubleshooting steps from the manual, I get

tsql -H hsldb.hermes.si -p 1433 -U itc (Note: no way to specify instance?)

locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
Msg 18456, Level 14, State 1, Server , Line 0
Login failed for user 'itc'.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

Note that the message doesn't match the message I would get if the server expected the domain login.

I'm lost.


Here is the entry from /etc/freetds/freetds.conf
[hsldbYukon]
host = hsldb.hermes.si
tds version = 7.0
port = 1433
instance = YUKON





Archive powered by MHonArc 2.6.24.

Top of Page