Home Forums SQL Server 2005 Business Intelligence SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER RE: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

  • All great info.

    I changed the encryption to none, but it made no change.

    What I did find out is the SQL Agent was running under the Local System and it would not run it. I changed the agent to use my username and it worked just fine.

    I now need to create a new service account with the proper privileges and it will run just fine.

    Thanks much