Forum Discussion
Can't schedule a refresh from a shared folder
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.
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.
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.
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.