Announcement

Collapse
No announcement yet.

Executing maintenance plans as another user

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Executing maintenance plans as another user

    We've created our maintenance plans when loggen in as the domain administrator but are changing the password.

    Is there a simple way to run these plans as another user?

  • #2
    Re: Executing maintenance plans as another user

    I guess If I cannot edit the plan to run as another user, simply login to Server as new said user and replicate the plan that was setup as administrator?

    Comment


    • #3
      Re: Executing maintenance plans as another user

      What SQL server permissions does the other account have -- it should have access to the plans
      Tom Jones
      MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
      PhD, MSc, FIAP, MIITT
      IT Trainer / Consultant
      Ossian Ltd
      Scotland

      ** Remember to give credit where credit is due and leave reputation points where appropriate **

      Comment


      • #4
        Re: Executing maintenance plans as another user

        I haven't set anything as yet, they are just members of the domain admin group.

        When I check the owner of the backup jobs, it's the domain\administrator, yet under security I only see administrators of builtin displayed in logins and not even in any server roles. I suspect even though we used domain admin to install SQL, some areas were assigned another dedicated account.
        Last edited by marcopolo; 18th January 2012, 17:45.

        Comment

        Working...
        X