The Acumen software design blog provides you with helpful articles about IIS.

Several web sites provide a good overview.

Microsoft Official IIS Overview

IIS Wikipedia

SQL Server

SQL Server

Problem

When migrating a Visual Studio project with a local SQL Server application database to IIS, you receive the following error:

“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.”

Resolution

In IIS, Select the appropriate application pool.  Change advanced settings->process model->Load User Profile value to true.

 

For more information about how Acumen can help with your software needs, contact us today!