Manually install sqlagent90.exe as a service

Is there a way to manually install sqlagent90.exe as a service?

I first have to ask, why? The SQL Agent is already a service and is installed that way when SQL Server is installed.

See: http://msdn2.microsoft.com/en-us/library/ms143504.aspx

for more help.

|||

We found the problem. At least 3 of our servers were missing the "Start" key in the registry for the SQL Agent service.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLAgent$SQL2005]
"Start"=dword:00000002

Apparently, Microsoft is having issues with the proper installation of the SQL Agent service for SQL Server 2005.

There are several postings on the internet related to the installation of this service, but none addressed this problem.

|||

Thanks for this feedback. I had not ever seen this problem before. Something good to know.