I have 2 Sharepoint servers ( one web and one index/search ) on windows 2003 and 1 back end database server sql 2008. I am having constant error message on both SQL
"Source MSSQLSERVER, Failure Aud Event ID 18456, User NT AUTH\SYSTEM, Computer: SERVERNAME "
I came across a solution as follows on the net
" This is caused when an SSP has been deleted, SQL holds on to a job under "SQL Server Agents" tied to that "old" ssp that he might have removed.... Use SQL Management Studio, connect to the db, find SQL server agents and then expand jobs... You should have lost the index if the SSP went bad, no worries..
Here you'll need to know the name of your old Shared Service Provider DB... Looks for something like SSPNAMEHERE_DB_DeleteExpiredSessions... If you're sure that's not in use you can either delete or disable the job and the errors will halt."
can somebody tell me what SSP and how to check it,
i attach the sql agent jobs
My Recommendation would be to login to Central Admin and look at the SSPs that are listed there. Then open SQL Server Management Studio and confirm the DBs for the SSPs listed in Central Admin. Then disable the SQL Job for any that don't match up.
Hope that helps.