title: SQL Server database is set Multi-User Mode and return error Single-User Mode
body: <p>My database always are set in multi-user mode, my connection string has option <code>mars = true</code>, but after check the database error logs I can frequently see this error message </p>
  
  <blockquote>
    <p>The server will drop the connection, because the client driver has sent <strong>multiple requests</strong> while the <strong>session is in single-user mode</strong>. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.</p>
  </blockquote>
  
  <p>I don't know what I forget to change for activate multi-user mode.... I try activate multi-user mode because is a the best recommendation after read some post by other users</p>
  
  <p>Why my session is in single user mode?</p>
  
  <p>Some friends recommend to use <code>mars = false</code> and avoid multi-user mode</p>
  
  <p>Is that a good idea ?</p>
  
  <p>The connection string</p>
  
  <pre><code>&lt;add name="BaseEntities"
  
  connectionString="metadata=res://*/BaseModel.csdl|res://*/WMSModel.ssdl|res://*/BaseModel.msl;&amp;#xD;&amp;#xA; 
       provider=System.Data.SqlClient;provider connection string=&amp;quot;Data Source=MyServer;&amp;#xD;&amp;#xA; Initial Catalog=MyDatabase;Persist Security Info=True;User ID=myuser;Password=mypassword;&amp;#xD;&amp;#xA;         
       MultipleActiveResultSets=True;Application Name=EntityFramework&amp;quot;"
       providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>After check db user-mode i get</p>
  
  <pre><code>SELECT user_access_desc 
  FROM sys.databases 
  WHERE name = 'MyDatabase'
  </code></pre>
  
  <p>return MULTI_USER</p>
  
  <p>I use C#, Entity Framework 4.X, SQL Server 2008</p>
  
  <p>Thanks for your attention</p>