BizTalk 09 and SQL R2 not SupportedBizTalk 09 and Project References

In a recent case the customer was attempting to install BizTalk 09 with SQL 2008 R2. It fails with the following error.

"Failed to create Management database 'BizTalkMgmtDB' on server 'XXXXX'. Error '0x80040E1d' occurred."

The server name is represented by the "XXXXX".

 

clip_image002

 

No follow up has been done to explain the problem. The BizTalk 09 product site does not mention support for this version of SQL.

Building Projects with BizTalk 09

Beware when building projects with BizTalk 09. There is a problem with references. There are various manifestations of the problem. Artifacts from referenced projects may not be available. Messages types requiring a reference to another project may not be available. Maps requiring schemas from referenced types are not available. The hot fix is under development and should be available in the near future. This could be a bigger problem as more symptoms are discovered. One fix may not fit all.