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

Posted by Sheonarayan under Error and Solution on 11/4/2013 | Points: 10 | Views : 961 | Status : [Administrator] | Replies : 0

Problem


I was getting following error when I was trying to implement Roles based authentication and checking for the Roles in ASP.NET MVC application on server.

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.


Solution


The solution of this problem is to configure Load User Profile setting in IIS. Follow below steps

1. Go to IIS
2. Open the Application pool for the website you are getting error in
3. Click on Advance Settings ... in the right panel
4. Under Process Model section, set "Load User Profile" to true.
5. Click OK and refresh your website and it should work.

Thanks and hope this will help someone.

Regards,
Sheo Narayan
http://www.dotnetfunda.com



Responses

(No response found.)

Login to post response