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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy