SQL Server Performance

Permissions with Maint Plans?

Discussion in 'SQL Server 2005 Integration Services' started by merrillaldrich, Sep 11, 2006.

  1. merrillaldrich New Member

    I have seen others complain of this, and now have experienced the joy myself:<br /><br />I have SSMS running on my workstation from which I administer a remote server. If I create a maintenance plan ON the remote server's SSMS using remote control software, then it works. However, if I create a maintenance plan using my copy of SSMS connected to the server, then it fails. The accounts that wind up as owners of the SSIS package that gets created are different -- the successful one is a local account on the box, and the remote one is a domain user. However, the domain user has both admin rights to the machine and sysadmin role within SQL Server.<br /><br />The closest I've been able to come is an error indicating that the SQL Server Agent issues an error that it cannot load the package created remotely, while it can (obviously) load the one created locally.<br /><br />Anyone else encountered this? What button do I push? <img src='/community/emoticons/emotion-1.gif' alt=':)' />

Share This Page