3

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?

4

Try to run a repair intallation from the installation media and then install service pack and cu after that.

You can run the repair from the command prompt:

Setup.exe /q /ACTION=Repair /INSTANCENAME=instancename  

Or by opening the installation center and select Maintenance in the left-hand navigation area, and then click Repair to start the repair.

Step-by-step instructions are found in the documentation

  • I was going to do that, but have to make arrangements first. I'll try this in a few days. – Alen Aug 14 '18 at 18:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.