Share Point / SQL Database
Posted on 2012-03-12
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