August 27, 2003 at 4:26 pm
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?
August 27, 2003 at 4:31 pm
There is a good faq on this site:
http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp
August 29, 2003 at 1:17 pm
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