The database “SERVER:BizTalkRuleEngineDb” associated with the deployment driver does not match the database “:” specified during production configuration

I had an issue recently at a clients site where after a deployment of an application to their test environment where everything seemed to go fine that when smoke testing it it was complaining that the BRE Policy it needed was not deployed, as the policy was a resource in the MSI that was deployed and this seemed very odd.

So first I checked in the application that the BRE Policy was part of, it was not to be seen, also trying to add it to the application I got the message “There are no policies that can be added to the application APPNAME”.  So next I checked under <All Artifacts>, Policies and sure enough it wasn’t visible there.

So next I tried manually Importing the Policy from BizTalk Server Administration Console (right click Policies under <All Artifacts> and select Import) but then I got the following error message.  “Unable to access Rule Store Provider.  Verify if Business Rule Engine feature is installed and configured”

BRE Error1
Screenshot: Unable to access Rule Store Provider. Verify if Business Rule Engine feature is installed and configured.

Initial Googling the above error mainly came up with sites referring to the Registry key HKEY_LOCAL_MACHINE\Software\Microsoft\BusinessRules\3.0\DatabaseName & DatabaseServer however this key was not present at all, as this was a 64 bit machine and it is actually HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\BusinessRules\3.0\DatabaseName & DatabaseServer and it was correctly populated.

The BizTalk Server Configuration also looked correct.

BRE Error3

Next I launched Microsoft Business Rule Composer.  In there I could see that the policy was actually there and in a published state.

So I tried deploying it and got the error “The database “SERVER:BizTalkRuleEngineDb” associated with the deployment driver does not match the database “:” specified during product configuration.”

BRE Error2
Screenshot: The “SERVER:BizTalkRuleEngineDB” associated with the deployment driver does not match the database “:” specified during the product configuration

Googling that error led me to the blog Error: The database BizTalkRuleEngineDb associated with the deployment driver does not match the database specified during product configuration   Which strangely hadn’t appeared in my initial search.  That blog then pointed me to look in the BizTalkMgmtDb at the adm_Group table, and sure enough as they had encountered the fields RuleEngineDBServerName and RuleEngineDBName were not populated.  Checking development and Production environments and these fields were populated.

BRE Error4

The blog above also had a link to Error Message: The database “.:BizTalkRuleEngineDb” associated with the deployment driver does not match the database “.:BizTalkRuleEngineDb” specified during product configuration.

This blog documented not only the registry key and the adm_Group database but also two other tables that refer to the  DB Server for the rule engine

  1. adm_OtherDatabases
  2. adm_OtherBackupDatabases

However these were correct.

So then wrote a SQL script to update this table.

use BizTalkMgmtDb

UPDATE dbo.adm_Group

SET RuleEngineDBServerName = ‘SERVERNAME’,

RuleEngineDBName = ‘BizTalkRuleEngineDb’

WHERE Id = 1

AND RuleEngineDBServerName = ”

AND RuleEngineDBName = ”

select RuleEngineDBServerName, RuleEngineDBName

from dbo.adm_Group

WHERE Id = 1

The next question, do any of the services related to BizTalk need to be restarted for the fix to take effect?

So I reproduced the issue in a Development environment and confirmed that I got the same symptoms and then applied the SQL script fix.  No restart of any of the BizTalk services was needed not even a restart of the BizTalk Server Administration console.   So I wrote up my release notes and got it approved for deployment which was promptly carried out and resolved the issue.


Published by Coen (Colin) Dijkgraaf

A BizTalk developer at Datacom Systems Ltd, Auckland, New Zealand. You can follow me on Twitter, StackOverflow and WordPress

Leave a comment

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog Of the Serverless Spirit

Stray Notions on All Things Microsoft Azure and BizTalk

Microsoft Azure/BizTalk_Read

Let's learn and share !

Boutaleb Hicham

Biztalk Architect

Pieter Vandenheede

Stories, tips & tricks for BizTalk Server, Azure, Data Science & Machine Learning

Glenn Colpaert

Blogging with my head in the (Hybrid) Cloud and my feet on premises! Azure / IoT / Integration


BizTalk blog by Knut Urke

Dragon's BizTalk Blog

A blog about BizTalk, and other integration tools.

The Deployment Bunny

OS Deployment, Virtualization, Microsoft based Infrastructure...

BizTalk Junkies

BizTalk, Azure and more..

Prasoon Gupta

If you know what you don't know, you know what you know.

Usman's blog

SOA - Azure, BizTalk, SharePoint, WCF

toon vanhoutte

Blogging about connecting devices, systems and people! On-premises and in the cloud. Microsoft stack only.

Simple Thoughts

Anything to free my mind... ~Nick Capito


Sprouting Bits

For healthier coding and balanced clouding ;) by Paco de la Cruz

%d bloggers like this: