Thanks for the response to my inquiry
I understand now that the user id and password I specify in the DSN string
should be a user id defined on the SQL server itself.
I will check my IIS setup ensure that it can use Windows authentication.
Thanks
Tony B. Okusanya
"Live Life By Design And Not From Crisis to Crisis"
From:
"Jenda Krynicky" <[EMAIL PROTECTED]>
To:
"perl-win32-users@listserv.ActiveState.com"
<perl-win32-users@listserv.ActiveState.com>
Date:
08/18/2008 12:07 PM
Subject:
Re: Help with DBI and SQL Server
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
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
U.S. BANCORP made the following annotations
---------------------------------------------------------------------
Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by electronic communications privacy
laws, and is also confidential and proprietary in nature. If you are not the
intended recipient, please be advised that you are legally prohibited from
retaining, using, copying, distributing, or otherwise disclosing this
information in any manner. Instead, please reply to the sender that you have
received this communication in error, and then immediately delete it. Thank you
in advance for your cooperation.
---------------------------------------------------------------------
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
