title: Adding user and password to Sql Server database
body: <p>My connection string defined in Web.Config currently indicatea no user or password is needed:</p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name="CinemaxConnectionString" connectionString="Data Source=PCName\SQLEXPRESS;Initial Catalog=Cinemax;Integrated Security=True"
        providerName="System.Data.SqlClient" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I would like to add user and password, like this:</p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name="CinemaxConnectionString" connectionString="Data Source=PCName\SQLEXPRESS;Initial Catalog=Cinemax;User=cinemax; Password=abc"
        providerName="System.Data.SqlClient" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>Obviously, this requires changing some settings <strong>in Sql Server to add user and password</strong>. What is the best way to do this? I specify I have Sql Server 2005 Express and the <strong>current authentcation mode is "Sql Server and Windows Authentication"</strong>.
  Thank you in advance for your help.
  It would be nice to see a double take on this: user-interface and code solution.</p>