Failed to generate a user instance of SQL Server due to failure in retrieving the user’s local

建了一個asp.net網站，使用membership身分識別驗證，在VS2010裡調試運行時，一切正常，但是到了IIS（7.5）下，就出現了如下錯誤：

Server Error in '/me' Application.
--------------------------------------------------------------------------------

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.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: 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.

 

經過一番嘗試，現提供有效解決辦法：

我的網站使用的是預設應用程式集區（DefaultAppPool），在DefaultAppPool上右擊，選Advanced Settings… ， 在快顯視窗裡面的Process Model項中，將Load User Profile的值改為True。重啟網站服務，運行成功。