title: deploying asp.net website on IIS giving problems why?
body: <p>i developed an asp.net site using forms based authentication, that site is working when i run from visual studio builtin server, but when i deploy it in a IIS server its showing following error when i tried to login</p>
  
  <pre><code>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.
  
  Source Error: 
  
  An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  
  </code></pre>
  
  <p>I am using asp.net default template but i configured user authorization through web.config file, like</p>
  
  <pre><code>&lt;authentication mode="Forms"&gt;
    &lt;forms loginUrl="~/Login.aspx" 
           name=".ASPXAUTH"
           path="/"
           requireSSL="false"
           slidingExpiration="true"
           defaultUrl="~/Admin/OrderHistory.aspx"
           cookieless="UseDeviceProfile"
           enableCrossAppRedirects="false"
           &gt;
      &lt;credentials passwordFormat="Clear"&gt;
        &lt;user name="Admin" password="adm123$"/&gt;
        &lt;user name="Administrator" password="adm234%"/&gt;
      &lt;/credentials&gt;
    &lt;/forms&gt;
  &lt;/authentication&gt;
  </code></pre>
  
  <h2>Imp info</h2>
  
  <p>i am able to logon using the VS builtin server but unable to login using IIS</p>
  
  <h2>EDIT</h2>
  
  <p>Hi after changing the process model identity to NetworkService the earlier error was gone but i am not able to login </p>
  
  <p>Every time its showing wrong credentials error message</p>
  
  <p>im using asp.net membership login control to get the username and password</p>
  
  <p>its working in VS builtin server</p>