title: The user instance login flag is not supported on this version of SQL Server. The connection will be closed, error login
body: <p>I have Windows 7, Microsoft SQL Server 2008 R2 and Visual Studio 2010.</p>
  
  <p>First question: I don't change my password in sql, although my security its setting follow:</p>
  
  <ul>
  <li>server authentication: sql server windows authentication mode</li>
  <li>login auditing: Failed logins only</li>
  </ul>
  
  <p>and for user sa or any users:</p>
  
  <pre><code>permission: Grant
  Login: Enabled
  </code></pre>
  
  <p>but, my any password will 32 numbers.</p>
  
  <p>Second question:</p>
  
  <p>Then, I never can connect to database in Visual Studio, such as Entity Framework way, with uid and with <code>Integrated Security=True;User Instance=True;</code></p>
  
  <p>So, when I <kbd>ctrl</kbd>+<kbd>f5</kbd> in VS, and I expect true working my app and ajax, I instead get error.</p>
  
  <p>My code:</p>
  
  <pre><code>function FillGrid() {
  
      $.ajax({
          url: "ajax_process.aspx?cmd=FillGrid",
          type: "POST",
          data: null,
          async: true,
          success: function (dataFromServer) {
              d = eval("(" + dataFromServer + ")");
              alert(d[0].email);
          },
          error: function (XMLResponse) {
              alert(XMLResponse.responseText);
          }
  
      });
  }
  </code></pre>
  
  <p>My error is alert:</p>
  
  <blockquote>
    <p>The user instance login flag is not supported on this version of SQL Server. The connection will be closed.</p>
  </blockquote>
  
  <p>and:</p>
  
  <blockquote>
    <p>SqlException (0x80131904): The user instance login flag is not supported on this version of SQL Server. The connection will be closed.]</p>
    
    <p>System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +6352224</p>
  </blockquote>