SQLServerAgent : Error 1331

  • SQLServeragent was working yesterday but not today since our application guy got ahold of the machine. It's a standalone on SQL Server 2000/Win2KServer. Getting the following errors: [298] SQLServer Error: 1331, Cannot generate SSPI context [SQLSTATE HY000] and also [000] Unable to connect to server '(local)'; SQLServerAgent cannot start

    The service is configured to logon to the local system account. NT Authority\System has sysadmin access within SQL Server. Anyone have any ideas?

  • There is a good faq on this site:

    http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp

  • Thanks...there are some issues with AD and replication. We're going to remove AD for other reasons. I was able to get SQLServerAgent to start anyhow by using a SQL Server id rather than the local system account. If the application still doesn't work after removing AD we may have to do a complete reinstall which should completely wipe out the errors I saw.

Viewing 3 posts - 1 through 2 (of 2 total)

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