In BizTalk server Configuration Business Rule was showing as sucessfully configured but when tried to Deply the published rule it was unable to search for the Database server and Database.
Error Description: The database “MyServer:BizTalkRuleEngineDb” associated with the deployment driver does not match the database “:” specified during product configuration.
Solution: First try to re configure the BizTalk Rule Engine from the BizTalk Configuration and try to deploy the rules from Business Rule Composer. If it doesnot work then try to edit the values in the BizTalk Mgmt Database (BizTalkMgmtDb) for the following table
1. adm_Group – Verify the server name and the Database name under column “RuleEngineDBServerName” and “RuleEngineDBName” are correct.
2. adm_OtherDatabases : Check for the Rules DB details It must be there in as a record. If not present Add one row with the details.
3. adm_OtherBackupDatabases. : Check for the Rules DB details It must be there in as a record. If not present Add one row with the details.
Hope this will resolve the problem.