If there is a SQL server installation that is physically missing the SQL Server Agent is there a way to add it without reinstalling SQL Server? Will installing a service pack do it?
Today I was asked to look at a SQL server another department had installed. It's SQL 2016 SP1 Standard Edition. SSMS shows SQL Agent, but there is no SQL Agent service in services or in Configuration Manager. And no mention of SQL Agent in the registry.
In the installation path I see the various SQL Agent files and I tried to register the service via the SC command but it didn't work. The service is there but it won't start.
Short of detaching the databases, uninstalling and reinstalling, is there anything else that can be done to get it working?