SQL Server 2000sp3a upgrade from wmsde, for sharepoint services, sql agent wont start
I have installed sharepoint services on windows server 2003, using wmsde as db server.
I have now upgraded wmsde to sql server 2000 sp3a, problem is SQL Agent wont start, error log shows 'SQLAgent is not allowed to run'. this happens using local system or domain account as service log on. I need to be able to schedule backups so this is a real pain.