title: Classic ASP Integrated Security in connection string
body: <p>I have old classic ASP application (not asp.net) that I need to configure to use Microsoft SQL Server 2008.
  It works well with following config string:</p>
  
  <pre><code>SERVER=myServer;DRIVER=SQL SERVER;DATABASE=myDatabase;UID=sa;PWD=somepass
  </code></pre>
  
  <p>But I need to use integrated security. But got error in any types of declaration that I tried. Something like that and a lot of variations don't work:</p>
  
  <pre><code>SERVER=myServer;DRIVER=SQL SERVER;DATABASE=myDatabase;Integrated Security=SSPI;
  </code></pre>
  
  <p>So my question is: how connection string should look like for Classic ASP integrated security. Or maybe additional web server configuration is needed?</p>