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.


Comments (3)

  1. baloodevil says:

    Any update on this?  I am trying to install Biztalk 2009 on SQL Server 2008 R2, and running into these problems.  Will this be supported, or at least some information on how to get the db stuff to run on the latest SQL Server version?

  2. Mukesh says:

    I ran into exactly the same problem. The error log kept giving the error that the login ID used to create the account is a local entity. At first, i thought maybe the AD account does not have log on as a service policy enforced. It won't create SSO service although would create the SSODB database. Windows Server R2 however works and has no issues.

  3. Issa Ayyash says:

    Biztalk 2009 doesnt support SQL2008 R2 , where as Biztalk 2010 aligns with SQL 2008 R2

Skip to main content