In IIS 7 there is section on Authentication. By default for Anonymous Authentication, the user identify is set to IUSR
Whilst its set to this I get SQL access errors.
If I change it to 'Application pool identity' the error goes away.
The application pool identity is set to 'Localsystem'
Presumably this is working because IIS is located on the same machine as the development environment and I'm logged on as the Administrator.
What should be the correct settings?