Failed to generate a user instance of SQL Server because of an error retrieving the user's local application data path

/"Server error in the application.

Failed to generate a user instance of SQL Server because of an error in retrieving the user's local application data path. Make sure that the user has a local user profile on this computer. The connection will be closed.

Stack trace:

[SqlException (0x80131904): An error occurred while retrieving the user's local application data path, resulting in a failure to generate a user instance of SQL Server. Make sure that the user has a local user profile on this computer. The connection will be closed. ] System.Data.SqlClient.SqlInternalConnection.OnError (SqlException exception, Boolean breakconnection) + 6256377 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning (tdsparserstateobject stateobj) +245

Failed to generate a user instance of SQL Server because of an error retrieving the user's local application data path

Issue: The Web application was debugged in VS2008, and when it was published to IIS, "there was an error in retrieving the user's local application data path, which caused the user instance of SQL Server to fail," a half-day answer was found on the Internet, or the answer was not found. So he had to do it by himself. Eventually explored because the application process pool workaround is not configured in IIS: iis-"Your local server-" application process Pool-"Select one, I choose the default that DefaultAppPool, and then right-click the Advanced Settings-" Process Model-" The load user profile is set to true so that we have a process pool configured

Select your website application-"Basic Settings-" Select the process pool you just set up, OK problem solved

Failed to generate a user instance of SQL Server because of an error retrieving the user's local application data path