title: SSIS connection manager login fails
body: <p>I have an SSIS project wherein I defined a Data Source (provider: Native OLE DB/Microsoft OLE DB Provider for SQL Server). When I open this up manually and hit the button "test connection" all works fine. The connection manager can access the DB using the connection string, user and password.</p>
  
  <p>Now I have an SSIS package where I created a connection manager based on this data source ("new connection from data source..."). </p>
  
  <p>In the package control flow I have an SQL task which has connection type OLE DB and connection is set to my connection manager within this very package. The task fires some update statement to the database, noting fancy at all.</p>
  
  <p>Now when I debug the whole thing I always get the same error: </p>
  
  <blockquote>
    <p>Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred.
    Error code: 0x80040E4D. An OLE DB record is available. Source:
    "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D
    Description: "Login failed for user 'myUser'."</p>
  </blockquote>
  
  <p>FYI: myUser equals the user name I have for my database.</p>
  
  <p>So my question is: what am I missing here? I really can't see what's wrong here. I'm really stuck here. Any hints greatly appreciated!</p>