Just transfered some DTS packaged form my 2000 server to 2008. I can connect to integration services fine with my sa account and enumerate the migrated packages. However when I try to expand the MSDB folder as a standard user account I get teh Execute permissions error. The standard user account is a member of a domain group which has login rights and is a user of the MSDB database. The domain group has been assisgned db_ssisltduser and db_ssisoperator role membership. I tried specificall running grant execute on sp_ssis_listfolder to "My Group" as well as specifically to the user account with not affect. ideas

I think the account needs to have these permissions: db_ddladmin db_ssisadminArthur My Blog

This didn't resolve my issue. The issue seems to have to do with assigning a default schema. When I assigned my user account the be_ssisoperator schema as the default I was able to view the packages. The problem is that I can not assign a default schema to a group. TITLE: Microsoft SQL Server Management Studio ------------------------------ Alter failed for User 'DOMAIN\GROUP'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+User&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The DEFAULT_SCHEMA clause cannot be used with a Windows group or with principals mapped to certificates or asymmetric keys. (Microsoft SQL Server, Error: 15259) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=15259&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------

It has something to do with how you created the account. Please see if this post helps: http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/7d46a024-7ed5-4c9b-b091-3640dc04f5a1/Arthur My Blog