February 11, 2009 at 8:10 am
Hi:
I'm trying to execute an SSIS job via the SQL Server Agent with a SQL user account that is not in the sysadmin role. I've created a credential, which references that SQL user account. I then created a SSIS Proxy that references the credential I created. The Proxy has been specified in the "Run As" dropdown of the job I've created. I've added the SQL user account as a principal to the Proxy. The SSIS package is hosted in SQL Server and I've added the credential user account to the msdb fixed server role "SQLAgentOperatorRole".
When executing the job, I receive an error:
"The LoadFromSQLServer method has encountered OLE DB error code 0x80040E14 (Only the owner of DTS Package 'MyPackage' or a member of the sysadmin role may create new versions of it.)"
When I add my SQL user account to the "sysadmin" server role, the job executes successfully. Does anyone know how to execute a schedule job with a SQL user account that is not in the "sysadmin" server role?
Thank you!
May 10, 2010 at 12:42 pm
Were you able to work around this issue?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply