November 1, 2011 at 12:20 pm
Hi all,
we have one new server installed with two instances. One is test and other is prod.
Server\prod instance is working good when i run ssis package using SQL Agent, But when i use Server\test I am getting the error:
Executed as user: Team\sqlserver. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 2:08:59 PM Could not load package "\MSDB\Package" because of error 0x80040E09. Description: The EXECUTE permission was denied on the object 'sp_ssis_getpackage', database 'msdb', schema 'dbo'. Source: Microsoft SQL Server Native Client 10.0 Started: 2:08:59 PM Finished: 2:08:59 PM Elapsed: 0.297 seconds. The package could not be loaded. The step failed.
I Have Sys admin privileges on that instance, Do i need more access? or Team\sqlserver needs anything more to execute the package?
Team\sqlserver has these privelages:
db_ssisoperator.
rs_execrole
db_ssisadmin
db_ssisltduser
sqlagentoperatorrole.
sqlagentreaderrole.
sqlagentuserrole.
Please help its urgent. I have searched so many forums since yesterday but couldn't get enough information about it.
November 1, 2011 at 1:21 pm
srilu_bannu (11/1/2011)
Hi all,we have one new server installed with two instances. One is test and other is prod.
Server\prod instance is working good when i run ssis package using SQL Agent, But when i use Server\test I am getting the error:
Executed as user: Team\sqlserver. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 2:08:59 PM Could not load package "\MSDB\Package" because of error 0x80040E09. Description: The EXECUTE permission was denied on the object 'sp_ssis_getpackage', database 'msdb', schema 'dbo'. Source: Microsoft SQL Server Native Client 10.0 Started: 2:08:59 PM Finished: 2:08:59 PM Elapsed: 0.297 seconds. The package could not be loaded. The step failed.
I Have Sys admin privileges on that instance, Do i need more access? or Team\sqlserver needs anything more to execute the package?
Team\sqlserver has these privelages:
db_ssisoperator.
rs_execrole
db_ssisadmin
db_ssisltduser
sqlagentoperatorrole.
sqlagentreaderrole.
sqlagentuserrole.
Please help its urgent. I have searched so many forums since yesterday but couldn't get enough information about it.
Have you checked the current rights on msdb.dbo.sp_ssis_getpackage, as suggested by the error message?
November 1, 2011 at 1:23 pm
how to check that?
November 1, 2011 at 1:37 pm
Hmm, I'm no DBA:-) This might help:
SELECT * FROM fn_my_permissions('msdb.dbo.sp_ssis_getpackage', 'OBJECT')
where permission_name = 'EXECUTE'
If it returns a row, you should have EXECUTE permission. If not, you might have to GRANT EXECUTE on it.
November 1, 2011 at 2:10 pm
It did return a row.
But I some how getting the error again.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply