Installation error: SQL Agent service must be started

Products

• Information Centric Analytics

Issue/Introduction

The following error message is displayed on the Data Sources page of the Symantec ICA Installation Wizard:

SQL Agent service must be started

However, the following command executed in PowerShell confirms the SQL Server Agent service is running on the target server hosting Microsoft SQL Server:

Get-Service -Name "SQLSERVERAGENT"

Environment

Release : 6.x

Component : Microsoft SQL Server

Cause

The account under which the installation wizard is running has not been assigned the sysadmin role in the target SQL Server instance.

Resolution

Assign the SQL Server sysadmin role to the account under which the installer is run.

Additional Information

In addition to the error message displayed by the installer, the following error message is captured in the installer's log file (RiskFabric.Installer.<yyyyMMdd>.log):

Could not determine SQL Server Agent state.

The log file is stored in the following path on the server hosting Internet Information Services (IIS):

%ProgramData%\BayDynamics\Logs