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