IIS 7 cannot log into Sql Server Database
I have an IIS 7 application that uses a domain login. (basic settings, connect as)

The application would log in as the server name at first until I set the application in it's own application pool.

Now the application gets the read data from a gridview but when I attempt to get the detailsview with edit permission it fails.

I had the database set to accept the machine as a read/write (and this worked) but I can't use this solution being the application could move to a different machine and I want it to use a specific set of credentials.

Any idea how to solve this?
IIS 7 cannot log into Sql Server Database
===

I have an IIS 7 application that uses a domain login. (basic settings, connect as)

The application would log in as the server name at first until I set the application in it's own application pool.

Now the application gets the read data from a gridview but when I attempt to get the detailsview with edit permission it fails.

I had the database set to accept the machine as a read/write (and this worked) but I can't use this solution being the application could move to a different machine and I want it to use a specific set of credentials.

Any idea how to solve this?