locked
Run SQL Agent Jobs without SysAdmin role RRS feed

  • Question

  • Hi,

    Im using sql server 2014 with alwayson, we are using a third party application. This application reset the SA password and encrypt it. Fortunately I decrypt it and get the password. This application remove all users sysadmin role. Now my problem is I'm unable to run any backup jobs in Agent, Is there any option available to run Agent jobs without sysadmin role. 


    Sunday, August 14, 2016 7:12 AM

Answers

All replies

  • create a power shell script and schedule it.

    Verify : http://sqlmag.com/powershell/powershell-lets-you-back-sql-server-your-way


    Regards, Pradyothana DP. Please Mark This As Helpful if it helps to solve your issue. ========================================================== https://social.technet.microsoft.com/Profile/pradyothanadp http://www.dbainhouse.blogspot.in/

    Sunday, August 14, 2016 8:52 AM
  • Give role SQLAgentOperatorRole

    http://www.sqlservercentral.com/Forums/Topic1438841-1526-1.aspx


    Please click Mark As Answer if my post helped.

    Sunday, August 14, 2016 8:57 AM
  • SQLAgentOperatorRole is already granted but no use :( 
    Im using ola 
    hallengren script to backup.
    Sunday, August 14, 2016 9:10 AM
  • Hi,

    First of all: that application which changes the sa password w/o your approval that should not be in any environment and/or the vendor *must* change the application. 

    You can use Ola's script properly w/o sysadmin role, please take a look on this article.

    I hope it helps.

    János


    There are 10 type of people. Those who understand binary and those who do not.

    My Blog | Hire Me

    Sunday, August 14, 2016 10:50 AM
  • Refer the following

    http://borishristov.com/blog/modifying-not-owned-sql-agent-jobs-without-being-a-sysadmin/


    Please click Mark As Answer if my post helped.

    Sunday, August 14, 2016 1:32 PM