title: The EXECUTE permission was denied on the object 'sp_ssis_getfolder', database 'msdb', schema 'dbo'
body: <p>folks.<br>
  I'm trying to use the copy wizard to copy my SQL SERVER 2008 database from my Windows 7 Professional 32 bit Acer laptop to my SQL SERVER 2008 Windows 7 home premium 64 bit Samsung Laptop.<br>
  The error is:
  While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80040E09 (The EXECUTE permission was denied on the object 'sp_ssis_getfolder', database 'msdb', schema 'dbo'.).</p>
  
  <p>The question has been answered:
  You could GRANT EXECUTE ON MSDB.DBO.sp_ssis_getfolder to [proxy]</p>
  
  <p>Or you could try adding that user to one of the dts/ssis operator/executor roles - starting with user, then operator, then admin to see what level it needs - or read the documentation.</p>
  
  <p>db_ssisadmin db_ssisoperator db_ssisltduser</p>
  
  <p>See the section under msdb here: <a href="http://msdn.microsoft.com/en-us/library/ms189121.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms189121.aspx</a> </p>
  
  <p>Please forgive me.  I took the courses in 2010.  I'm working on a volunteer project. I understand what this answer wants me to do, but I don't know how or where to do it.   </p>
  
  <p>The following answer was great, but when I right click on the stored procedure, I don't get "properties" to select.  </p>
  
  <p>Check to make sure the user trying to run the stored proc has execute permissions, you can do this in SQL Server Management Studio by going to the Database -> Programmability -> and Right Click on the Stored Proc and select 'Properites', then go to the 'Permissions' section and see if your user is there, if its not, you can add the user and give it EXECUTE permissions, or you can do the following in a new query:
  GRANT EXECUTE TO  ON  </p>
  
  <p>I am connecting with logins that are owners on both databases.  I am assuming that the execute permission is going to be on the destination server, the msdb database. I am working on the destination (Samsung) laptop connecting to the source database on the Acer, right clicking on the source database and selecting "tasks", copy database.  Things work fine until the Wizard gets to CREATE and then it fails with the error.  </p>
  
  <p>I hope somebody can help me with this.  I've been trying to get this working for about a week and am frustrated.
  Thank you for your help.   </p>