Error configuring BAS

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