By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,692 Members | 1,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,692 IT Pros & Developers. It's quick & easy.

DBI, NT Authentication, CGI, and Apache

P: 1
I'd like to post database query results on a HTML page. I use Activestate Perl and DBI; my SQL server is SQL 2005, which I can only log in to using my NT authentication. My problem is with establishing a connection. Typically I use something like:

Expand|Select|Wrap|Line Numbers
  1. DBI->connect ("dbi:ODBC:driver=SQL Server;server=$server;database=$database")
I don't specify the username or password because it defaults to the trusted connection. But if I do this using CGI under Apache, the trusted connection doesn't work since Apache doesn't run under my NT credentials. I've tried to specify my username and password, but if I do this it doesn't use the NT authentication (it tries to do SQL authentication).

Is there some way I can specify my username and password and have it use NT authentication?
Nov 22 '08 #1
Share this Question
Share on Google+
1 Reply


eWish
Expert 100+
P: 971
I would suggest that you perhaps ask this question in the windows forum.
Nov 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.