title: Classic ASP - SQL Server 2008 Connection String using Windows Authentication
body: <p>This should be painfully simple, but I cannot come up with a working connection string for a local copy of SQL Server 2008 using Windows Authentication. I've tried using the Data Link Properties tool to create a connection string and it has no problems connecting, but when I copy paste the generated string into my ADODB.Connection object's ConnectionString property I get all sorts of fun and different errors.</p>
  
  <pre><code>Set conn = Server.CreateObject("ADODB.Connection")
  conn.ConnectionString = "SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=climb4acure;Data Source=(local);"
  </code></pre>
  
  <p><code>Microsoft OLE DB Service Components (0x80040E21)
  Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.</code></p>
  
  <p>I've tried a variety of similar connection strings but I cannot find one that will work with Windows Authentication. Can someone point me in the right direction?</p>
  
  <p>Thanks!</p>