Sharepoint generates EventID 18456 on SQL server

Posted on 2012-08-20
Last Modified: 2012-08-20
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:

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.
Question by:patrickd26
    LVL 44

    Accepted Solution

    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:


    Author Closing Comment

    "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!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
    Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now