oh man-

i know this is an old post, but i was having the exact same problem and i couldnt find and answer anywhere on Super Search or Google.

the problem is that under iis, dbi doesn't use the username and password you specify, it uses the default iis user. i found this out when checking the log file generated by adding this line before my connect:

    DBI->trace(9, 'C:\dbitrace.txt')
[download]

to rectify this, i changed the connection string to contain the username and password. i am using SQL Server so my dbi connection string looks something like this:

'dbi:ODBC:DRIVER={SQL Server};SERVER=theserver;DATABASE=thedb;UID=user
+id;PWD=password'
[download]

here are more examples of ODBC connection strings.

hopefully- someone will find this usefull