I've got something odd going on. I've written a custom web part that
attaches to a database. When I set the connection string to use a sql
account, all works fine. When I set the connection string to use integrated
security, it works fine on a development machine but not on production
machines.
The app pool for the portal is set to run as a domain account on the
production machines. I can open SQL Query Analyzer on that same machine and
successfully connect to the db using NT authentication, so the domain
account *should* have all the necessary permissions.
First question - web parts run under the identity of the App Pool, correct?
Any other thoughts?
-craig