(Windows Server 2003) Cannot run SQLSERVERAGENT service under non admin user after SP1 Installat

Hi All,

I need a hand here, referring to this knowledge base on Microsoft (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811) i applied this knowledge base, and it worked, the MSSQL and SQLSERVERAGENT have run under local non admin account.

But after i installed SP1, MSSQL service is ok, but SQLSERVERAGENT wont run. The warning message is : "Some service run and then stop if they have no work to do."

Is there any way i can install SP1 but in the same time run SQLSERVERAGENT under local non admin account?

Your assistance will be much appreciated

thank you very much in advance.

Felix Adhitya

[853 byte] By [FelixAdhitya] at [2007-12-23]

SQL Server

Site Classified