title: Password mismatch while logging to sql server
body: <p>Alright,
  I have a classic asp application and I have a connection string to try to connect to db.</p>
  
  <p>MY connection string looks as follows:</p>
  
  <pre><code> Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial
   Catalog=mydb;database=mydb;User Id=me;Password=123
  </code></pre>
  
  <p>Now when I'm accessing db though front-en I get this error: </p>
  
  <pre><code>Microsoft OLE DB Provider for SQL Server error '80040e4d'
  Login failed for user 'me'. 
  </code></pre>
  
  <p>I looked in the sql profiler and I got this: </p>
  
  <pre><code> Login failed for user 'me'.  Reason: Password did not match that
   for the login provided. [CLIENT: &lt;named pipe&gt;]
   Error: 18456, State:8. 
  </code></pre>
  
  <p>What I've tried:</p>
  
  <ol>
  <li>checked 100 times that my password is actually correct.  </li>
  <li>Tried this: <code>alter login me with check_policy off</code> (Do not even know why I did this)</li>
  <li>Enable ALL possible permissions for this account in SSMS.</li>
  </ol>
  
  <p>Update:
  4. I've tried this connection string: <code>Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial Catalog=mydb;database=mydb; Integrated Security = SSPI</code></p>
  
  <p>And I got this error: </p>
  
  <blockquote>
    <p>Microsoft OLE DB Provider for SQL Server error '80004005'
    Cannot open database mydb requested by the login. The login failed.</p>
  </blockquote>