DBI, NT Authentication, CGI, and Apache

[valpal]

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:

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?

[eWish]

I would suggest that you perhaps ask this question in the windows forum.