Verify the database server

Log in to 

Microsoft SQL Server Management Studio

 as the NGAD user.

Verify that the NGDeliverylog, NGDelivery_<

plug-in

>, NGDeliveryAccount, and NGDiagnostics exist on the same database server. 

Check the database directory and verify that there are files for the database installed on the server.

Open the ngdelivery_<

plugin_name

> database to verify that the Service Broker is enabled:

Select from the dbo.AsyncSqlQuery table.
In the query results, check the following values:
LastRunOn
 should be close to the current time
LastRunOK
 should be ‘1’ 

If the service broker is not enabled, run the following query: 

alter database RestoreDBName set enable_broker with rollback immediate