Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

I had to set the account of the application pool to my user

http://learn.iis.net/page.aspx/624/application-pool-identities/

in the above tutorial there is a section: Configuring IIS Application Pool Identities

just set it to 'custom account' instead of a default user.

Now I can use ssip access from the machine to my db for read/write

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.