DBI and FreeTDS Named Instances

tux402 has asked for the wisdom of the Perl Monks concerning the following question:

Greetings Monks,

I am having quite a hard time with this problem. I'm trying to connect to a MS sql server 2000 using FreeTDS and DBI. The trick is that I can only use NT Authentication, and I have to connect to a sql named instance. I can connect from Windows if I create the Windows user on my box, then use SQL Server Management Studio 2005, but not from Perl's DBI. Here is my dsn for reference. I and am not connecting locally.

#!/usr/bin/perl
use DBI;
my $host = '127.0.0.1\InstanceName';
my $usr = 'HostName\UserName';
my $pw = 'Password';
my $dsn = DRIVER=/usr/local/lib/libtdsodbc.so;SERVER=$host;PORT=4433;D
+ATABASE=dataBase;UID=$usr;PW=$pw;TDS_Version=8.0";
my $dbh = DBI->connect('DBI:ODBC:'.$dsn) || die $DBI::errstr;
[download]

I keep getting the error

[FreeTDS][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I'm not sure what is going wrong. I don't know if it is failing because of the NT authentication, or because of the named instance. Something to note, the sql server is not a part of the domain, and its hostname does not currently resolve to the IP. Any clues?

Comment on DBI and FreeTDS Named Instances Select or Download Code

Replies are listed 'Best First'.
Re: DBI and FreeTDS Named Instances by dreadpiratepeter (Priest) on Aug 10, 2009 at 23:59 UTC
If you are running on windows, you don't need to pass the username and password fields, they should get picked up automatically from your login. -pete "Worry is like a rocking chair. It gives you something to do, but it doesn't get you anywhere."	[reply]
Re^2: DBI and FreeTDS Named Instances by tux402 (Acolyte) on Aug 11, 2009 at 02:30 UTC
Yes that's true, and that works fine, but we are trying to pull from a Linux server. This makes the connection that much trickier.	[reply]
Re^3: DBI and FreeTDS Named Instances by dreadpiratepeter (Priest) on Aug 11, 2009 at 03:11 UTC
in that case the issue is going to be a configuration issue with freetds. It took me forever to get it right. remember that you have to configure the servers in freetds.conf and the dbs in the .odbc.conf file in the home directory of the user running the code. -pete "Worry is like a rocking chair. It gives you something to do, but it doesn't get you anywhere."	[reply]
Re^4: DBI and FreeTDS Named Instances by Anonymous Monk on Aug 11, 2009 at 14:29 UTC
Re^5: DBI and FreeTDS Named Instances by dreadpiratepeter (Priest) on Aug 11, 2009 at 16:12 UTC
Some notes below your chosen depth have not been shown here
Re^4: DBI and FreeTDS Named Instances by Anonymous Monk on Aug 11, 2009 at 14:30 UTC

Back to Seekers of Perl Wisdom