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:
If you have installed the rule processing components on a 64-bit version of Windows, they key will be at:
Change the following keys DeploymentDriverAssembly and DeploymentDriverClass values under the key.
Microsoft.BizTalk.RuleEngineExtensions, Version=126.96.36.199, Culture=neutral, PublicKeyToken=31bf3856ad364e35
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:
Don’t bother changing them;it does not matter.
Once I made that single entry, I could deploy policies again.