title: Microsoft Access: connecting to SQL Server via Active Directory username and password Trusted_Connection=no
body: <p>I have a Microsoft Access Application which generates a connection string like:</p>
  
  <pre><code>Provider=SQLNCLI11;Server=servername;Database=db_name;Trusted_Connection=yes;
  </code></pre>
  
  <p>This works without any problem.</p>
  
  <p>What I want to do is to connect to a SQL Server instance where the user must insert his Active Directory name and password.</p>
  
  <p>Like this:</p>
  
  <pre><code>Provider=SQLNCLI11;Server=servername;Database=db_name;Uid=username;Pwd=password;
  </code></pre>
  
  <p>This only works for users which are created on the SQL Server directly.</p>
  
  <p>I tried <code>Uid=DOMAIN\username</code>, but it isn't working.</p>
  
  <p>Is this possible? Or is there another way how I can get through this?</p>
  
  <p>The environment:
  The User is using a local PC with a local account and then he's doing a "NetworkConnect" with his AD-User and password.</p>
  
  <p>After that, "RunAs" as his AD-User is working BUT there is another Application that is started from the Access Application and this App must be started with the local User-Account.</p>
  
  <p>SQL-Server and the AD-User are member of the same domain.</p>