Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLServerAgent : Error 1331 Expand / Collapse
Author
Message
Posted Wednesday, August 27, 2003 4:26 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 193, Visits: 924
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?




Post #15716
Posted Wednesday, August 27, 2003 4:31 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, April 12, 2013 9:43 PM
Points: 537, Visits: 28
There is a good faq on this site:
http://www.sqlservercentral.com/columnists/cmiller/cannotgeneratesspicontext.asp




Post #76908
Posted Friday, August 29, 2003 1:17 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 193, Visits: 924
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.






Post #76909
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse