title: Error with Membership CreateUser
body: <p>I am creating a new user programmatically (will be adding custom profiles later) and am working on Win2K8 VM:</p>
  
  <pre><code>MembershipUser newUser = 
      Membership.CreateUser(userNameTxt.Text, passwordTxt.Text, emailTxt.Text);
  Roles.AddUserToRole(userNameTxt.Text.Trim(), "Member");
  </code></pre>
  
  <p><strong>UPDATE:</strong> </p>
  
  <p>Connection string:</p>
  
  <pre><code>&lt;remove name="LocalSqlServer" /&gt;
  &lt;add name="LocalSqlServer" 
      connectionString="Initial Catalog=MYS;Data Source=WIN2K8;uid=MYS;password=xxxxxx;"   
      providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>Getting the following error:</p>
  
  <p>System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\MYAPP'.</p>
  
  <pre><code>&lt;membership&gt;
        &lt;providers&gt;
          &lt;remove name="DefaultMembershipProvider"/&gt;
          &lt;add 
              name="DefaultMembershipProvider" 
              type="System.Web.Providers.DefaultMembershipProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
              connectionStringName="LocalSqlServer" 
              enablePasswordRetrieval="false" 
              enablePasswordReset="false" 
              requiresQuestionAndAnswer="false" 
              requiresUniqueEmail="false" 
              minRequiredPasswordLength="6" 
              minRequiredNonalphanumericCharacters="1" 
              passwordAttemptWindow="10" 
              applicationName="/" /&gt;
              &lt;/providers&gt;
      &lt;/membership&gt;
      &lt;roleManager enabled="true"&gt;
  </code></pre>