[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 738
  • Last Modified:

Sharepoint generates EventID 18456 on SQL server

We've been having a ton of EventIT 18456 logged in our event viewer on SQL.  An ip listed in the event points the culprit to our Sharepoint box.  After further analysis we determined that it was a state 38 error.  From all this information we found this article:

http://www.mssqltips.com/sqlservertip/2581/sql-server-error-18456-finding-the-missing-databases/ 

That article will allow you to determine which database SP is trying to connect to.  We confirmed that the db does not exist on SQL and that the service trying to connect on SP was no longer being used.  We ended up deleting the service through the SP powershell.  That cleaned up the logs a lot.  In stead of 10 or so errors a second we are now seeing about 2 errors every 15 minutes.  That still bothers us.  

How can I stop SP from trying to connect to SQL with this orphaned service?  Is there a way to pause it or completely remove it?

I have tried pretty much everything that I can think of and no luck.  Any help is much appreciated.
0
patrickd26
Asked:
patrickd26
1 Solution
 
Rainer JeschorCommented:
Hi,
I assume there is still a timer job which would be executed by the SharePoint timer service every 15 minutes.
Which service did you delete?
Here is a broad overview of the timer jobs:
http://technet.microsoft.com/en-us/library/cc678870.aspx

HTH
Rainer
0
 
patrickd26Author Commented:
"Timer Job" was it exactly!  I went in there and saw about 8 jobs referencing the old service that was deleted.  As I disabled them, they automatically removed themselves from the list.  The errors appear to be gone now!  Thank you!  I'm glad SOMETHING finally went right on a Monday!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now