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?