I'm encountering two distinct errors when attempting to manually execute or schedule SSIS packages on my SQL Server 2019. Despite thorough checks on permissions and configurations, these errors persist, preventing any SSIS package from running. I'm seeking insights or solutions to overcome these hurdles.
This error comes when the SSIS package is started by the SQL Job with the SQL Server Agent
Retrieving the COM class factory for component with CLSID {6E8597AE-3486-4838-A8E0-F5C683618DF4} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
This error comes when the SSIS package is manually started from the SSIS catalog.
Creating an instance of the COM component with CLSID {6E8597AE-3486-4838-A8E0-F5C683618DF4} from the IClassFactory failed due to the following error: c0010014 Exception from HRESULT: 0x80070005 ; Exception from HRESULT: 0xC0010014;
The problem was a missing Windows permission for the executing user.
We created a new blank Windows user and a corresponding Proxy User.
Important was den Windows user role that we gave him.