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: 9261
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 2 years, 1 month ago by mtz676.

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

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

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

mtz676 SSCrazy Eights Points: 9261 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 2 years, 1 month ago by mtz676.

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

Phil Parkin

SSC Guru

Points: 247180

August 8, 2023 at 10:33 am

#4255757

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

mtz676 SSCrazy Eights Points: 9261 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: 247180 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.

mtz676 SSCrazy Eights Points: 9261 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 2 years, 1 month ago by mtz676.

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

mtz676 SSCrazy Eights Points: 9261 More actions · Answer 8

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