Feb 032011
 

So I created a script that created a silent install of BizTalk from a server that had SQL server installed to having BizTalk, clinic pills UDDI, hospital and ESB installed. I figured I was pretty ‘tricky’ by using the dot as the database server name.

However, no rx when I went to deploy a rule from within the Business Rule Engine, I received the following error: Error Message: The database “.:BizTalkRuleEngineDb” associated with the deployment driver does not match the database “.:BizTalkRuleEngineDb” specified during product configuration

I looked over a few blog entries, where the registry needed to be altered:

Open the Registry Editor (regedit) and locate the following key:

HKEY_LOCAL_MACHINESOFTWAREMicrosoftBusinessRules3.0

If you have installed the rule processing components on a 64-bit version of Windows, they key will be at:

HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicrosoftBusinessRules3.0

Change the following keys DeploymentDriverAssembly and DeploymentDriverClass values under the key.  

    Microsoft.BizTalk.RuleEngineExtensions, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35    

Microsoft.RuleEngine.RuleSetDeploymentDriver

NADA

The ultimate solution was to go into the adm_Group table and change the server name

image

There are two other databases that also refer the DB Server for the rules engine:

  1. adm_OtherDatabases
  2. adm_OtherBackupDatabases

Don’t bother changing them;it does not matter.

Once I made that single entry, I could deploy policies again.