From: [EMAIL PROTECTED]
> Hello all
> I am trying to use a perl script to pull information from a SQL
> 2000 database
> The problem I am having is with authentication using an Active directory
> account. The script works
> just fine if I use an account defined in SQL.
> below is my sample script
>
>
> use DBI;
> my $user='Domain\\userid';
> my $pw ='password';
> my $DSN = "driver={SQL Server};Server=DEVSERVERDB09
> ;database=hwdbInfo;uid=$user;pwd=$pw;";
> my $dbh = DBI->connect("dbi:ODBC:$DSN") or die "$DBI::errstr\n";
This tries to find a login named 'Domain\userid' in the list of SQL
Server's own logins.
> I usually just rely on the users local credentials to access the database
> but this tool is going to be web based and we need each user to login
> using their domain credentials
Rely on them again. If you leave the credentials checking to IIS it
should run the scripts under the users' accounts so it should just
work.
Jenda
===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz =====
When it comes to wine, women and song, wizards are allowed
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
