locked
Manually install sqlagent90.exe as a service RRS feed

  • Question

  •  

    Is there a way to manually install sqlagent90.exe as a service?
    Wednesday, September 26, 2007 5:01 PM

All replies

  • 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.

     

    Wednesday, September 26, 2007 7:43 PM
  • 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.

     

    Wednesday, September 26, 2007 8:02 PM
  • Thanks for this feedback. I had not ever seen this problem before. Something good to know.

    Wednesday, September 26, 2007 8:05 PM