Written by: Michael Stephenson (http://geekswithblogs.net/michaelstephenson)
Just came across an error while configuring BAS. In the log file it contained the details below:
[00:36:30 Error Configuration Framework]Feature: [BAS] Failed to configure with error message [<Exception Message="Error -2147467259 occurred configuring feature TPMConfig" Source="TPMConfig" HelpID=""><Exception Message="An error was encountered in executing the SQL script C:\Program Files\Microsoft BizTalk Server 2006\Schema\BTS_Version_Logic.sql on database BizTalkMgmtDb Server WIN2003AD.
Detail: (null)" Source="TPMConfig" HelpID=""><Exception Message="The database specified has an incompatible version. Specify a new database name." Source="TPMConfig" HelpID=""/></Exception></Exception>]
I think this is because the server was setup as a BizTalk 2006 Developer machine (without BAS) and then upgraded to BizTalk 2006 R2. At a later date I was then trying to setup BAS and got the error. I think the install is expecting a certain version of the database.
I was able to work around this in the BizTalk configuration wizard by setting a new database name for BAS. This means the Trading Partner database objects are in a different database.
Unfortunately I dont have a machine in a state where I can fully confirm the assumption I am making here, but logging this post incase it helps anyone else