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?