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
Icon for Resolver II rankResolver 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?

  • muchinski's avatar
    muchinski
    Icon for Resolver II rankResolver II
    8 years ago

    On your report server configurations, the connection is made with NT AUTHORITY\Network Service, but you gave permissions to NT AUTORITY\SYSTEM. They are different users -> I believe that this is the problem.

     

    Why don’t you try to change the database configurations of your report server to use the built-in suggest account (more secure)? Or create a database user for your PBIRS authentication?