troubleshooting Question

Share Point / SQL Database

Avatar of Eric
EricFlag for Canada asked on
Microsoft SharePointMicrosoft SQL Server 2005Microsoft SQL Server 2008
12 Comments1 Solution465 ViewsLast Modified:

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

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros