CommServer PreUpgrade Report Verify SQL Server Agent is started. Failed

Hey ​@Thomas Trendel 

This is worthy a case with CommServe support team, fix it once and use the KB/Fix after that for whenever you get the issue, better work with support to identify the root cause and release a fix if possible.

Else, I can see Arlie suggests 2 points valid to check,

1. Check if the SQL service account has sysadmin role
   • User Account Configuration for the SQL Server Agent
   • Configuring User Accounts for the SQL Server Agent
2. Check if the service name in the registeries match it on MS services, and check below PowerShell command

   • Get-Service *SQL*Agent*

Thanks,

Abdu

Hi ​@Thomas Trendel ,

The CheckSQLAgent script is unable to correctly identify the SQL Server service status because the operating system language is set to German. As a result, the script cannot match the expected service status values.

Kindly follow the steps below to update the service status name accordingly and then re-run Setup.exe to proceed with the installation:

 

Execute admin Terminal: 

Set-Service -Name 'SQLAgent$COMMVAULT' -DisplayName 'SQL Server Agent (COMMVAULT)'

Then rerun query from sql studio SELECT * FROM sys.dm_server_services WITH (NOLOCK)
Ensure that query output shows SQL Server Agent (COMMVAULT)

Once the above steps are completed resume the upgrade and let us know the results.