Challenge
When trying to start a collection job manually or when running the job automatically, you receive the following start/stop error:
Typically, you can just start Veeam Reporter Scheduling Service to resolve the issue, but sometimes you receive the following error instead:
Scheduling service is stopped
while the service is running.
Cause
There are two possible root causes for this issue:
-
The account used to run Reporter Scheduling Service lacks permissions on the SQL Server and needs to be granted the relevant permissions on the Veeam Reporter database.
-
Sometimes the service and the GUI fall out of synchronization.
Solution
Grant db_owner permissions on the Veeam Reporter database to the account used to run Reporter Scheduling Service. To do so, follow the next steps:
-
Stop Veeam Reporter Scheduling Service in the Windows Services snap-in.
-
Make note of the account used to run Scheduling Service.
-
Log on to the SQL Server instance hosting the Veeam Reporter database.
-
Go to Security. Right-click Logins and choose New Login.
-
On the General tab of the New login window, search for the domain user account used to run Veeam Reporter Scheduling Service.
-
Go to the User mapping tab and check the Veeam Reporter database. In the Database role membership for section, grant the db_owner permissions to the user account.
-
Start Veeam Reporter Scheduling Service.
Verify whether this helps. If the issue remains, try the following workaround:
Uninstall Reporter, keep the existing database, and reinstall the software pointing to the existing database. This will re-register the Windows service to the GUI, and this should fix the issue. If after the reinstall you receive the same error with the same behavior, follow the next steps:
-
Uninstall Reporter v4.
-
Detach the current database with historical data.
-
Move the database to a new location to avoid DB name conflict.
-
Install Reporter v4 on the SAME SQL Server and the SAME instance with the SAME database name.
-
Verify that Scheduling Service is running and working properly (in green).
-
While the service is running, detach the NEW database with no data.
-
Move the database to a new location to avoid DB name conflict.
-
Move the old database to the default location (original location).
-
Attach the old database to the SAME SQL Server and the SAME instance.
-
Refresh Reporter v4. Make sure that Scheduling Service in the GUI and in Windows works properly with historical data.
More Information
If you have any questions or problems, please contact Veeam Support at http://www.veeam.com/support