I have a windows 2000 server running SQL Server 2000. This past week we moved this server into Active Directory. SQL Server Agent ran without errors for 4 days. Now I cannot get the SQL Server Agent to start.
The network engineer had a policy running that when a computer is added to the AD domain it automatically goes to "homeless" container and renames administrator account. The account was not pre-created so all of the above happened.
Error messages in event log are:
"SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start)."
When I try to start SQL Agent I get this message
 SQLServer Error: 53, Cannot generate SSPI context [SQLSTATE HY000