May 8, 2014 at 10:38 am
i have strange sssis package runs in sql server 2005 calling via sql agent file system, package use connection string to connect for sql server 2008 where data need to load from file. string is used Provider=SQLOLEDB.1;Integrated Security=SSPI; it has been failing intermittently. Anyone has similar issue and fixes for this issue? when i run from bids in sql server 2005 box it runs fine. sql error: DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. Hresult: 0x80004005 SQL Server does not exist or access denied."
May 13, 2014 at 12:23 pm
Sounds like Agent permissions. Can't tell ya much more than that as someone else here handles all config and security issues at server level.
May 13, 2014 at 3:21 pm
When you run a package through a SQL Server Agent job, it uses the permissions of the Agent service account.
You either give that service account sufficient permissions on the SQL Server box, or you use a proxy to delegate permissions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply