I have an SQL server 2005 and SQL Express as well as a SQL 2012 server. I built a package that will export data from an SQL Express (2005) database into a SQL 2005 server. This package works great when I run the package alone but when I try to run it through Jobs it fails with the following error.
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID
to the user NT SERVICE\SQLSERVERAGENT SID (S-1-5-80-344959196-2060754871-2302487193-2804545603-1466107430) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.
I have tried fixing it through Componenet Services however I dont know where to look to fix this issue. I know this is a permissions issue but where to fix it?