Deployed to IIS 7 RIA Service cannot access database with "Integrated Security=True" .
Cause: Service uses IIS App Pool with "ApplicationPoolIdentity" which is not known to SQL Server.
Fix: Make App Pool to use LocalSystem as identity (IIS -> Application Pools -> (select/create one) -> Advanced Settings -> Process Model/Identity.
Source: Login failed for user 'IIS APPPOOL\DefaultAppPool'
Tuesday, February 9, 2010
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment