If you’re following Microsoft’s Best Practice recommendations for securing SQL Server 2000, you should be running the SQL Server and SQL Server Agent services under separate domain user accounts (not the Local System account). Whilst setting this up you may encounter this error:
Adding the SQL Server service user account to the Administrators group fixes the problem, but does not adhere to Best Practices.
More info:
- Microsoft Support: How to change the SQL Server or SQL Server Agent Service account without using SQL Enterprise Manager in SQL Server 2000 (283811)
- http://www.dbforumz.com/-Error-22022-running-SQLservices-accounts-ftopict149813.html