locked
BizTalk 2013 and SQL Server 2014 RRS feed

  • Question

  • I installed BizTalk 2013 server on Windows 2012 R2 Update 1.Post installation, I tried to configure BizTalk using SQL Server 2014 as the backend database but I am getting an error in the configuration wizard at BAM Tools step. The error is reproduced here:

    TITLE: Microsoft BizTalk Server Configuration Wizard
    ------------------------------

    Microsoft SQL Server 2008 R2 with SP1 or higher is not installed on INLVK84GP4. (BAMTools)

    For help, click: http://go.microsoft.com/fwlink/events.asp?ProdName=Microsoft+BizTalk+Server+2013&ProdVer=3.10.229.0&EvtSrc=BAMTools&EvtID=idsSqlNotInstalled

    ------------------------------
    ADDITIONAL INFORMATION:

    Installed version 12.0.2000.8 is not supported. (Microsoft.BizTalk.Bam.CfgExtHelper.Utility)

    For help, click: http://go.microsoft.com/fwlink/events.asp?ProdName=Microsoft+BizTalk+Server+2013&ProdVer=3.10.229.0&EvtSrc=Microsoft.BizTalk.Bam.CfgExtHelper.Utility&EvtID=error_UnsupportedVersion

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    As per this article - http://msdn.microsoft.com/en-us/library/jj248684%28v=bts.80%29.aspx#BKMK_WSS, BizTalk 2013 supports SQL Server 2014.

    My system configuration:

    Windows 2012 R2 Update 1, with 8 GB RAM, Workgroup (no domain), SharePoint 2013 SP1 installed, Office 2013 SP1 installed, VS 2012 update 4 installed. I am creating a development environment for myself and this is not a production server.

    Monday, April 14, 2014 11:47 AM

Answers

  • Just to clarify:

    BizTalk Server 2010

    Windows Server 2008, Windows Server 2008 R2

    Visual studio 2010

    SQL Server 2008, SQL Server 2008 R2

    ---------------------------------------------------------------

    BizTalk Server 2013

    Windows Server 2008 R2, Windows Server 2012

    Visual studio 2012

    SQL Server 2008 R2, SQL Server 2012

    ---------------------------------------------------------------

    BizTalk Server 2013 R2

    Windows Server 2012, Windows Server 2012 R2

    Visual studio 2013

    SQL Server 2012, SQL Server 2014

    And even though other operation systems than the supported ones might work, this is all that is supported.

    Morten la Cour


    • Marked as answer by maheshc Tuesday, April 15, 2014 8:26 AM
    Tuesday, April 15, 2014 7:56 AM

All replies

  • As the error clearly stated SQL Server 2014 is not supported with BizTalk yet (2013).

    "Microsoft SQL Server 2008 R2 with SP1 or higher is not installed on INLVK84GP4" & "Installed version 12.0.2000.8 is not supported"

    Generally SQL Server always release the latest version much ahead of BizTalk release cycle. Its been told that only after 6 months of the new versions,  BizTalk will have an update to support the latest platform. SQL Server 2014 just released, BizTalk is not updated to go along with the latest version yet. 

    With SQL Server, the latest supported version is SQL Server 2012.

     


    If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply.



    Monday, April 14, 2014 11:53 AM
  • BizTalk 2013 is not upwards compatible, so a version of SQL Server released after BizTalk 2013 is not supported.

    Jean-Paul Smit | Didago IT Consultancy
    Blog | Twitter | LinkedIn
    MCTS BizTalk 2006/2010 + Certified SOA Architect

    Please indicate "Mark as Answer" if this post has answered the question.

    Monday, April 14, 2014 11:57 AM
  • Also BizTalk Server 2013 is not supported on Windows Server 2012 R2


    Morten la Cour

    Monday, April 14, 2014 12:37 PM
  • Hi,

    For 2014, we can expect a BizTalk 2013 R2 with Platform alignment for Windows Server 2012 R2, SQL Server 2014 and Visual Studio 2013.

     

    Kind regards,

    Tomasso Groenendijk

    Blog  |  Twitter
    MCTS BizTalk Server 2006, 2010

    If this answers your question please mark it accordingly

    Monday, April 14, 2014 1:06 PM
  • Hi

    In my query, I had quoted an MSDN article: http://msdn.microsoft.com/en-us/library/jj248684%28v=bts.80%29.aspx#BKMK_WSS,%20BizTalk%202013

    This article states that BizTalk 2013 supports SQL Server 2014.

    Mahesh


    • Edited by maheshc Tuesday, April 15, 2014 7:01 AM
    Tuesday, April 15, 2014 7:00 AM
  • Hi

    In my query, I had quoted an MSDN article: http://msdn.microsoft.com/en-us/library/jj248684%28v=bts.80%29.aspx#BKMK_WSS,%20BizTalk%202013

    This article states that BizTalk 2013 supports SQL Server 2014.

    Mahesh


    • Edited by maheshc Tuesday, April 15, 2014 7:02 AM
    Tuesday, April 15, 2014 7:01 AM
  • Hi

    In my query, I had quoted an MSDN article: http://msdn.microsoft.com/en-us/library/jj248684%28v=bts.80%29.aspx#BKMK_WSS,%20BizTalk%202013

    This article states that BizTalk 2013 supports SQL Server 2014 and Visual Studio 2013.

    Mahesh


    • Edited by maheshc Tuesday, April 15, 2014 7:02 AM
    Tuesday, April 15, 2014 7:01 AM
  • Interesting, the article you mention does show SQL 2014 is supported ("SQL Server 2014 and SQL Server 2012 SP1 are the minimum requirements").

    I guess it is a mistake in the this article.

    On the Hardware and Software Requirements page for BizTalk 2013 it shows wat we expect: "SQL Server 2012 or SQL Server 2008 R2 SP1".

    http://msdn.microsoft.com/en-us/library/jj248697(v=bts.80).aspx


    Jean-Paul Smit | Didago IT Consultancy
    Blog | Twitter | LinkedIn
    MCTS BizTalk 2006/2010 + Certified SOA Architect

    Please indicate "Mark as Answer" if this post has answered the question.


    Tuesday, April 15, 2014 7:36 AM
  • This article also states that you should install Visual Studio 2013, which also is not supported!!

    This must be a mixture of documentation for BizTalk Server 2013 and the upcoming BizTalk Server 2013 R2. In general when it comes to BizTalk and documentation, MS has proven to be...how should I put this...."Not always too smart!".

    la Cour


    • Edited by la Cour Tuesday, April 15, 2014 1:09 PM
    Tuesday, April 15, 2014 7:45 AM
  • Just to clarify:

    BizTalk Server 2010

    Windows Server 2008, Windows Server 2008 R2

    Visual studio 2010

    SQL Server 2008, SQL Server 2008 R2

    ---------------------------------------------------------------

    BizTalk Server 2013

    Windows Server 2008 R2, Windows Server 2012

    Visual studio 2012

    SQL Server 2008 R2, SQL Server 2012

    ---------------------------------------------------------------

    BizTalk Server 2013 R2

    Windows Server 2012, Windows Server 2012 R2

    Visual studio 2013

    SQL Server 2012, SQL Server 2014

    And even though other operation systems than the supported ones might work, this is all that is supported.

    Morten la Cour


    • Marked as answer by maheshc Tuesday, April 15, 2014 8:26 AM
    Tuesday, April 15, 2014 7:56 AM
  • Hi Morten

    Thanks for the correct list. Now, if only someone will update the related MSDN article.... :-)


    Mahesh

    Tuesday, April 15, 2014 8:27 AM
  • Hi All,

    Lets be clear, latest version of official release of BizTalk is 2013, not 2013 R2. Release of 2013 R2 is expected in sometime in second quarter of 2014 (as per BizTalk product manager in his speech in London BizTalk Summit 2014).

    Help file (http://msdn.microsoft.com/en-us/library/jj248684%28v=bts.80%29.aspx#BKMK_SQL) is certainly seems to be sneak peak of BizTalk’s future release, which we have to ignore at the moment. I’ll raise this with BizTalk team.

    Support requirements for the latest BizTalk is as follows:

    • BizTalk Server 2013

    Windows Server 2008 R2, Windows Server 2012

    Visual studio 2012

    SQL Server 2008 R2, SQL Server 2012


    If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply.

    Tuesday, April 15, 2014 8:51 AM
  • Updated to this issue: Documentation team has been updated, they will correct this page and would remove the BizTalk 2013 R2 specific requirements until its officially released.

    If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful by clicking the upward arrow mark next to my reply.

    Tuesday, April 15, 2014 4:58 PM