title: Connecting to a local SQL Server database
body: <p>While making <code>web.config</code>, I tried to connect local SQL Server database with the web</p>
  
  <pre><code>&lt;add key="DSN" value="server=localhost;uid=test_demo;pwd=1234;database=DB_PRE"/&gt;
  </code></pre>
  
  <p>However using "DSN" with value server = localhost does not successfully connected to the local SQL Server database. And I'm not sure with creating <code>uid</code> and <code>pwd</code> I want to know how to use "DSN" to connect to the local.</p>
  
  <p>I'm using SQL Server 2008, IIS Express 7.</p>