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.