cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alanoudfahad
Frequent Visitor

Can't schedule a refresh from a shared folder

Hello!

 

I have a dashboard that is using data from a shared folder and I want to schedule a refresh in the report server but I keep getting this error message:

1 ACCEPTED SOLUTION


@Alanoudfahad wrote:

if you can share the process of how to setup a SQL agent in report server?


SQL Agent is normally installed and enabled as part of the default install of SQL Server, so the bigger question is how did it get switched off in the first place.

 

If you remote desktop onto your SQL Server and start the SQL Server Configuration Manager tool you can click on services then right click on the SQL Agent service and start it from there.

d_gosbell_0-1629069079941.png

 

If you don't see SQL Agent at all then you would need to run the SQL Server install again and add SQL Agent to your instance.

 

I would also recommend going into the Properties, then under the service tab make sure the startup type is set to Automatic so that SQL Agent will restart whenever the server is re-started.

View solution in original post

3 REPLIES 3
d_gosbell
Super User
Super User


@Alanoudfahad wrote:

Hello!


SQL Agent is the mechanism that Report Server uses internally to trigger the refresh at the time you specified in the schedule regardless of what the source of your data is. It needs to be running if you want any timed operations to occur. 

Thank you for your replay..

 

if you can share the process of how to setup a SQL agent in report server? This is my first time using RS and not sure how to configure the SQL agent


@Alanoudfahad wrote:

if you can share the process of how to setup a SQL agent in report server?


SQL Agent is normally installed and enabled as part of the default install of SQL Server, so the bigger question is how did it get switched off in the first place.

 

If you remote desktop onto your SQL Server and start the SQL Server Configuration Manager tool you can click on services then right click on the SQL Agent service and start it from there.

d_gosbell_0-1629069079941.png

 

If you don't see SQL Agent at all then you would need to run the SQL Server install again and add SQL Agent to your instance.

 

I would also recommend going into the Properties, then under the service tab make sure the startup type is set to Automatic so that SQL Agent will restart whenever the server is re-started.

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!