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 is the Error I get from the above line of code (using domain login):
DBI connect('driver={SQL Server};server=DEVSERVERDB09;database=hwdbInfo
;uid=Domain\userid;pwd=password;','',...) failed: [Microsoft][ODBC SQL
Server Driver][SQL Server]Login failed for user 'Domain\userid'.
(SQL-28000) at H:\\Dev\T.pl line 8
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'Domain\userid'. (SQL-28000)
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
any help would be appreciated.
Tony B. Okusanya
"Live Life By Design And Not From Crisis to Crisis"
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
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
