January 5, 2004 at 11:03 am
I have created several DTS packages that run if I execute them immediately, but error out if scheduled with the following error...
Executed as user: Domain\Username. DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.
January 5, 2004 at 11:41 am
Check the Agent proxy account
* Noel
January 6, 2004 at 12:19 pm
I have verified that the account it uses when scheduled (its the same account that is used to start the SQL agent) has full privlages to the database.
Is there something I should be checking ?
January 6, 2004 at 3:24 pm
You probably do not have the privilege to execute jobs on the server. Change the resulting job ownership to a login that has execute job permission after you schedule the DTS package.
Joseph
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply