SQL Server

SQL Server


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!