SQL Server Performance Forum – Threads Archive

Permissions with Maint Plans?

I have seen others complain of this, and now have experienced the joy myself: 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. 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. Anyone else encountered this? What button do I push? <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />

]]>