SQL Server Agent won''t start

  • 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

    [298] SQLServer Error: 53, Cannot generate SSPI context [SQLSTATE HY000

    Any suggestions? 

    Thanks!

    Sharon

  • This was removed by the editor as SPAM

  • My problem has been resolved.  Thanks anyway!

  • What fixed the problem - I am getting the same message

  • any fix for this??? urgent today!!!!!!!!!!!

  • [font="Verdana"]Try the below KB article.

    http://support.microsoft.com/kb/843248[/font]

  • I have experienced this is the past: resolution - check your password or the user name for their access. Also, check the error message and research the error # related to the problem - you may find this in the eventvwr - under the application.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply