When installing the DyKnow Database Server, you may receive an error message
"SQL Server Agent service (SQLSERVERAGENT) must be installed on this machine to continue the installation"
This error is thrown because DyKnow is unable to find the SQL Server Agent in the services list. There are a number of scenarios in which this error could occur, but this article covers two that are common.
To view the services running on the server, click the start button and select Run. Type 'services.msc'.
Scenario 1 - SQL Server Agent is missing
If the SQL Server Agent is not in the list, verify that you are using the correct version of SQL Server. DyKnow does not support SQL Express. To resolve this, install a supported version of SQL Server. For more information on supported versions of SQL Server, please visit this article.
Scenario 2 - There is a named instance of SQL Server
DyKnow does not support named instances of SQL Server. If your SQL Server Agent is from a “named instance” installation, then DyKnow will throw an error. See the example shown below of a SQL “named instance” installation named (DYDB)
(Note: In the above example, the DYDB in parentheses is for a “named instance” installation and is shown here for example purposes only. It could have been named something other than DYDB.)
To resolve this, make sure to install the DyKnow Database Server on a SQL Server that is not a “named instance” installation. The DyKnow Database Server may be installed on a SQL Server that is running multiple databases for applications other than DyKnow.