locked
Conect Biztalk 2006 R2 to SQL Server 2012 RRS feed

  • Question

  • Hello,

    In my environronment i am using biztalk server 2006R2 version and this is connected to SQL server 2005 database.recently microsoft not supported SQL Server 2005R2.So we are migrated SQL server 2005 to SQL server 2012.Now the question is i am planning to connect Biztalk server 2006R2 is connect to SQL server 2012 database.Is it possible or not.

    If possible please tell me how to proceed.

    thank you,

    Raj

    Tuesday, October 4, 2016 3:12 PM

Answers

  • Hi

    I am afraid, that is not supported. The highest SQL server supported with BizTalk 2006 R2 is SQL Server 2005.

    Since you have already migrated to SQL Server 2012, you have to migrate to either BizTalk Server 2013, or BizTalk Server 2013 R2(needs SQL Server 2012 Service Pack 1). You can find the supported versions of SQL for each BizTalk Server version below-

    https://support.microsoft.com/en-in/kb/926628


    Thanks Arindam


    Tuesday, October 4, 2016 3:14 PM
    Moderator
  • Hi Raj,

    For the BizTalk Server Databases (MessageBox, Management, etc), no, SQL Server 2012 is not supported with BizTalk Server 2006 R2..

    As a target for the WCF SQL Adapter (sqlBinding) yes, it is supported

    Anyhow, there is no point asking SQL server compatibility both for application connectivity or for setting up Biztalk Server databases as the BizTalk Server version you are currently using has crossed Extended support End date as well. 

    Refer: https://social.technet.microsoft.com/wiki/contents/articles/18709.biztalk-server-product-lifecycle.aspx

    If you wish your infrastructure should be supported by Microsoft then you need to upgrade to a newer version of BizTalk Server.

    You can utilize SQL server 2012 which you currently have licensed by either upgrading to BizTalk Server 2013 or BizTalk server 2013 R2. For BizTalk Server 2013 R2 you will require SQL Server 2012 Service pack 1.

    You can upgrade directly from the 2006 R2 (not 2006 though) project system to 2013 R2 directly in Visual Studio 2013.

    Keep in mind, there are notable differences in the platforms from 2006 R2 to 2013 R2, most significantly, the change from .Net 2.x to .Net 4.x.  You will have to test all the applications before deploying to the new setup.

     

    Rachit Sikroria (Microsoft Azure MVP)

    Wednesday, October 5, 2016 10:49 AM
    Moderator

All replies

  • Hi

    I am afraid, that is not supported. The highest SQL server supported with BizTalk 2006 R2 is SQL Server 2005.

    Since you have already migrated to SQL Server 2012, you have to migrate to either BizTalk Server 2013, or BizTalk Server 2013 R2(needs SQL Server 2012 Service Pack 1). You can find the supported versions of SQL for each BizTalk Server version below-

    https://support.microsoft.com/en-in/kb/926628


    Thanks Arindam


    Tuesday, October 4, 2016 3:14 PM
    Moderator
  • No this is not possible. This setup and configuration is not supported and will lead to issues. You should plan migrating to Biztalk2013R2. Support for 2006R2 has also expired.

    Pi_xel_xar

    Blog: My Blog

    BizTalkApplicationDeploymentTool: BizTalk Application Deployment Tool

    LinkedIn: LinkedIn

    Tuesday, October 4, 2016 3:16 PM
    Answerer
  • Hi RAJ,

    Forward compatibility is not possible in this case meaning...BizTalk 2006 R2 version can not be used with SQL sever 2012...there is no way in which this can work...

    Have you considered the option of the upgrade of the whole Biztalk stack to an upper version of Biztalk may be 2013 R2 or 2016(which will be released soon)

    Regards


    Mandar Dharmadhikari

    Tuesday, October 4, 2016 3:18 PM
    Moderator
  • Hi Raj,

    For the BizTalk Server Databases (MessageBox, Management, etc), no, SQL Server 2012 is not supported with BizTalk Server 2006 R2..

    As a target for the WCF SQL Adapter (sqlBinding) yes, it is supported

    Anyhow, there is no point asking SQL server compatibility both for application connectivity or for setting up Biztalk Server databases as the BizTalk Server version you are currently using has crossed Extended support End date as well. 

    Refer: https://social.technet.microsoft.com/wiki/contents/articles/18709.biztalk-server-product-lifecycle.aspx

    If you wish your infrastructure should be supported by Microsoft then you need to upgrade to a newer version of BizTalk Server.

    You can utilize SQL server 2012 which you currently have licensed by either upgrading to BizTalk Server 2013 or BizTalk server 2013 R2. For BizTalk Server 2013 R2 you will require SQL Server 2012 Service pack 1.

    You can upgrade directly from the 2006 R2 (not 2006 though) project system to 2013 R2 directly in Visual Studio 2013.

    Keep in mind, there are notable differences in the platforms from 2006 R2 to 2013 R2, most significantly, the change from .Net 2.x to .Net 4.x.  You will have to test all the applications before deploying to the new setup.

     

    Rachit Sikroria (Microsoft Azure MVP)

    Wednesday, October 5, 2016 10:49 AM
    Moderator