So I created a script that created a silent install of BizTalk from a server that had SQL server installed to having BizTalk, UDDI, and ESB installed. I figured I was pretty ’tricky’ by using the dot as the database server name.
However, 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_MACHINE\SOFTWARE\Microsoft\BusinessRules\3.0
If you have installed the rule processing components on a 64-bit version of Windows, they key will be at:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\BusinessRules\3.0
Change the following keys DeploymentDriverAssembly and DeploymentDriverClass values under the key.
- Microsoft.RuleEngine, 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
There are two other databases that also refer the DB Server for the rules engine:
- adm_OtherDatabases
- adm_OtherBackupDatabases
Don’t bother changing them;it does not matter.
Once I made that single entry, I could deploy policies again.