Just ran into this and thought I?d share. If you are trying to connect to SQL Server from your Web application running on Windows 7 or Windows 2008 R2 and you?re getting a message that looks like this: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed. I can probably help you out. The IIS team made a change to the default identity of the worker process. Starting with IIS 7.5, Application Pools run with a unique identity based on the Application Pool name, rather than NetworkService ? the default identity for IIS6 and IIS7. The primary reason for...(read more) ...
Go to the complete details ...