title: Why does SSIS connection works with Windows but not with SQL Server authentication?
body: <p>I have an SSIS package that contains a Lookup Transformation. This requires a connection to the database. At the connection manager, when I use the <em><code>Windows authentication</code></em> the connection works fine but when I use <em><code>SQL Server Authentication</code></em> then I get this error:</p>
  <blockquote>
  <p>[A140_DAMAGETYPETEXT [3799]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager &quot;servername.Datenbankname.sqlUser&quot; failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.</p>
  </blockquote>
  <h3>Connection string:</h3>
  <blockquote>
  <p>Data Source=TheServerName;User ID=TheSQLUser;Initial Catalog=TheDababase;Provider=SQLNCLI10.1;Persist Security Info=True;Application Name=NameOfThePackage{80F4BFAB-642D-457E-9F47-1E811AFA48D0}ServerName.TheDababas‌​e.TheSQLUser;</p>
  </blockquote>