title: Sql Authenticated Connection String for AspNetDb
body: <p>Before I begin I would like to say I have already checked thoroughly at <a href="http://www.connectionstrings.com" rel="nofollow">www.connectionstrings.com</a> and looked at all possible threads at this forum for an answer.</p>
  
  <p>Right now my connection string is like this:</p>
  
  <pre><code>&lt;add name="LocalSqlServer"
       connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
       providerName="System.Data.SqlClient"/&gt;
  </code></pre>
  
  <p>Its working, but I can only access it in my App_Data folder<br/>
  <strong>I want to access this database from the SQL SSMS, therefore I have tried changing it like this:</strong></p>
  
  <pre><code>&lt;add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;
       Database=AspNetDb;InitialCatalog=ASPNETDB; User Id=kaneXtreme;Password=password123!;User Instance=true" providerName="System.Data.SqlClient"/&gt;
  </code></pre>
  
  <p><strong>I have also tried this</strong></p>
  
  <pre><code>&lt;add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Database=AspNetDb;
       Initial Catalog=ASPNETDB; User Id=kaneXtreme;Password=password123!" providerName="System.Data.SqlClient" /&gt;
  </code></pre>
  
  <p>Both of which I have tried changing is resulting in this <strong>Configuration error</strong> when I open up localhost:</p>
  
  <blockquote>
    <p>The entry <code>LocalSqlServer</code> has already been added.</p>
  </blockquote>
  
  <p>Advice please.</p>