Notification Alert System crash after any unrelated error of OLE DB initialization - by ellight1

Status : 


Sign in
to vote
ID 775018 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 12/22/2012 7:32:38 AM
Access Restriction Public


We using log error notification service: SQL Server Agent -> Alerts
Correspondingly logging errors (RAISERROR WITH LOG;) sends message by e-mail to admins

If anywhere, any provider with external context run fails on initialization, then alert system will fall off. And only system/service restart restores it.

At the same time other mechanisms, such as providers, e-mail etc. continues normal function (though some of them doesn't immediately, it depends)

Links for settings instructions:

The use of an external context run is necessary due to problem providers with memory leaks and crashes (Oracle provider for example)
Sign in to post a comment.
Posted by Sethu Srinivasan on 2/3/2015 at 6:58 PM
Please install latest service pack and let us know if you still see this issue

Sethu Srinivasan [MSFT]
SQL Server