Run SSIS from ASP.net

in sql 2005 sp1,
when I try to run a package from an asp.net page
the following statement generate error:
myPackage = integrationServices.LoadFromDtsServer(packagePath,
"myServerName", Nothing)
error:
EXECUTE permission denied on object 'sp_dts_getpackage', database 'msdb',
schema 'dbo'.
I followed "Kirk Haselden" instruction on how to assign permissions for
remote user but did not solve the issue.
thanks for help
what permissions should be assigned and to which user.Hello,
This issue may occur if the identity of application pool of asp.net
application does not have the proper permission on msdb database.
You may want to run inetmgr and check the identity of the Website hosting
the asp.net application. If it is "network service", you may add "nt
authortiy/network service" to login of SQL Server, and grant it proper
permission on msdb SQL Server.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||I assigned "nt authortiy/network service" the right permissions on procedure
s
sp_dts_getpackage and sp_dts_listpackages, but now I'm getting another error
:
"
Only the owner of DTS Package 'myPackage' or a member of the symin role
may create new versions of it.
"
I was checking those procedure and find a check on the dts owner.
I can disable these checks, but worried that would affect something else on
the server.
any other work arround ?
thanks|||Hello,
As mentioned in the error message, you may want grant SQL server symin
role to the login to work around the issue but it may bring security risk.
Based on my scope, Usually disabling these check shall not have other
effect on the server.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.sql