title: Connect to SQL server (Windows Authentication) via Classic ASP
body: <p>hey, I wanna connect to sql with windows Authentication either sql server authentication but frankly i can't :</p>
  
  <p>this is my connection string : </p>
  
  <pre><code>&lt;%
  Dim conn
  Set conn = Server.CreateObject("ADODB.Connection")
  'conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = Northwind; User Id=Mohammad-PC/Mohammad; Password="
  conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = Northwind; User Id=sa; Password="
  If conn.errors.count = 0 Then
  Response.Write "Connected OK"
  End If
  %&gt;
  </code></pre>
  
  <p>and i get this error :</p>
  
  <pre><code>Microsoft OLE DB Provider for SQL Server: Login timeout expired
  </code></pre>
  
  <p>i've set session timeout to 10mins but still same.
  i use IIS 7.5 and sql server 2005</p>