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: 9212
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 1 year, 3 months ago by mtz676.

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

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

Phil Parkin SSC Guru Points: 246960 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?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

mtz676 SSCrazy Eights Points: 9212 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 1 year, 3 months ago by mtz676.

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

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

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

mtz676 SSCrazy Eights Points: 9212 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: 246960 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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

mtz676 SSCrazy Eights Points: 9212 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 1 year, 3 months ago by mtz676.

Phil Parkin SSC Guru Points: 246960 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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

mtz676 SSCrazy Eights Points: 9212 More actions · Answer 8

Does this need to be fixed or is the message informational.