Pages

Friday, December 31, 2010

Server Error ( IIS 7.0)

Question : -Server Error ( IIS 7.0 ) 
Operating System : Windows Server 2008
I get the error shown in the screenshot when I try to create a user account on ASP.NET website.
If possible, please give me the step by step procedure as to what needs to be done.





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.


Solution: - Please check your connection string, if user setting and DB details are fine. Also check if DB service is running fine. You can see the various types of connection strings here : http://www.connectionstrings.com/
to check the SQL connection string you can see the details in your web.config. And can try to telnet on port 1433 (default SQL port , can be different in your environment ) or you can make a test ODBC connection from Administrative tools. 


****AS IS**** ; Apply at your own risk.

No comments:

Post a Comment