Event ID 19036 & 10016 from Application and System log at the same time

Question

Event ID 19036 & 10016 from Application and System log at the same time

mtz676

SSCrazy Eights

Points: 9184
More actions
August 8, 2023 at 6:35 am

#4255581
The OLE DB initialization service failed to load. Reinstall Microsoft Data Access Components. If the problem persists, contact product support for the OLEDB provider.
Why do those 2 event IDs occur at the same time and what does it mean.
What does this error mean?Where should I start to troubleshoot this and fix it.
Is this a benign error as below stated in the URL
https://learn.microsoft.com/en-US/troubleshoot/windows-client/application-management/event-10016-logged-when-accessing-dcom
or does this need to resolved.
Solutions available:
https://answers.microsoft.com/en-us/windows/forum/windows8_1-performance/error-event-id-10016-distributedcom/130522d2-beac-4495-980a-65e1e3279901
https://darrenabbott.wordpress.com/2015/08/05/error-the-ole-db-initialization-service-failed-to-load-when-using-linked-server/#:~:text=The%20solution%20was%20to%20right,the%20problem%20we%20were%20having).
Thanks
- This topic was modified 9 months ago by mtz676.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246713 More actions · Answer 1

Is this something which has just started happening? If so, do you have any new jobs running which get data from other sources?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

mtz676 SSCrazy Eights Points: 9184 More actions · Answer 2

Hello Phil, We see this once in a while and not a recent occurence. Twice in the last 30 days.Yes there is a SQLJob which inserts data into a different server using linked servers.

The linked server provider is Microsoft OLE DB Provider for SQLServer.

For the SQLOLEDB provider "Allow inprocess" is not checked. Is this what needs to be checked to correct this error.

Thanks

This reply was modified 9 months ago by mtz676.

Phil Parkin SSC Guru Points: 246713 More actions · Answer 3

OK, does it happen randomly, or only at set times?

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

mtz676 SSCrazy Eights Points: 9184 More actions · Answer 4

I checked the SQLJob timings and the times this error occured.It seems to occur at random times.

Phil Parkin SSC Guru Points: 246713 More actions · Answer 5

mtz676 wrote:

I checked the SQLJob timings and the times this error occured.It seems to occur at random times.

You mean the Event Viewer, presumably? OK, I don't know what to suggest and hope someone else can help.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

mtz676 SSCrazy Eights Points: 9184 More actions · Answer 6

These 2 event IDs 19036 & 10016 show in the event viewer and this "The OLE DB initialization service failed to load. Reinstall Microsoft Data Access Components. If the problem persists, contact product support for the OLEDB provider." is what shows up in the error log at the same times.

This reply was modified 9 months ago by mtz676.

Phil Parkin SSC Guru Points: 246713 More actions · Answer 7

Understood. But you mentioned 'SQLJob timings' and I was simply wanting to confirm that you had referred to this in error.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.