Forum Discussion

fatemehdashti's avatar
fatemehdashti
Regular Visitor
8 years ago

can not create scheduled refresh plan

Hi everybody, Please help me When I want to create scheduled refresh plan, this error occures: ****The SQL Agent service is not running, This option requires the SQL Agent service.**** I checked m...
muchinski's avatar
muchinski
Resolver II
8 years ago

Hi fatemehdashti, the user account used to connect Power BI Reporting Services Service to the Report Server database must be, at least, member of the SQLAgentOperatorRole on msdb database, in order to create jobs. (refresh plans create jobs internally to deal with schedules)

 

Can you check that? It is a permission on the server that hosts the Report Server database.

  • fatemehdashti's avatar
    fatemehdashti
    Regular Visitor
    8 years ago

    Thanksmuchinski, I set my user properties like below, Do you mean this? Unfortunatelly the error is shown again, Please guide me more.

    • muchinski's avatar
      muchinski
      Resolver II
      8 years ago

      Hi, I meant the user that connect PBIRS to the database. You can find it using Report Server Configuration Manager (image bellow).

       

      In addition, do you see any error message on SQL Agent Log? 

      • fatemehdashti's avatar
        fatemehdashti
        Regular Visitor
        8 years ago

        Hi, my Report Server Configuration Manager is:

        Also I set login properties for "NT AUTORITY\SYSTEM" like this:

        But I still see some errors on SQL Agent log:

        and It is showen previous error again whenI create a scheduled refresh plan. I'm really confuesed. What do I do now?