title: How to connect to MS SQL Server database from ASP using windows authentication specifying a windows user
body: <p>I've been trying for just over a month to connect an ASP script here to a SQL Server database
  but each time I use this connection string:<br/>
      <code>Data Source=dbServer01;Initial Catalog=POS123;Integrated Security=SSPI;User ID=domain\usr;Password=pwd;</code></p>
  
  <p>It ignores the user I specify and takes the machine name to authenticate the connection, which obviously fails.</p>
  
  <p>so I change the Integrated Security value to False, like this:<br/>
      <code>Data Source=dbServer01;Initial Catalog=POS123;Integrated Security=False;User ID=domain\usr;Password=pwd;</code></p>
  
  <p>I then get an error: Login Failed for user "domain\usr" which is impossible because it works when we test the connection with it in the odbc admin app.</p>
  
  <p>I asked the help of a senior and he said it's taking the user name as a database user name, but we need to make it use windows authentication, and specify which user to use.
  I remember reading about this a month ago and finding that there was no way to specify a user and password when connecting using windows authentication with this version of ASP.NET.
  I'm going to kill myself soon If I can't get this script to connect, someone save me please!</p>