1/7/16

Summary of supported operating systems, SQL Server and Visual Studio by BizTalk Server

This article lists the versions of Windows, SQL Server, Visual Studio, and .NET Framework versions that are supported with Microsoft BizTalk Server 2006 R2 and newer.
Supported operating systems

BTS 2013 R2BTS 2013BTS 2010BTS 2009BTS 2006 R2
Windows XPNoNoNoYes, with Windows XP Service Pack 3Yes, with Windows XP Service Pack 2 or later service pack
Windows XP Professional, 64-Bit EditionNoNoNoYes, with Windows XP Service Pack 3Yes, with Windows XP Service Pack 2 or later service pack
Windows Server 2003NoNoNoYes, with Windows Server 2003 Service Pack 1 or later service packYes, with Windows Server 2003 Service Pack 1
Windows Server 2003, 64-Bit EditionNoNoNoYesYes
Windows Vista, including 64-bitNoNoYes, with Windows Vista Service Pack 2 or later service packYes, with Windows Vista Service Pack 1 or later service packYes
Windows Server 2008, including 64-bitNoNoYesYesNo
Windows 7, including 64-bitYes, with Windows 7 Service Pack 1 or later service packYes, with Windows 7 Service Pack 1 or later service packYesNoNo
Windows Server 2008 R2, including 64-bitNoYes, with Windows Server 2008 R2 Service Pack 1 or later service packYesNoNo
Windows Server 2012YesYesNoNoNo
Windows Server 2012 R2YesNoNoNoNo
Windows 8NoYesNoNoNo
Windows 8.1YesNoNoNoNo

Reference Microsoft Support Page: https://support.microsoft.com/en-us/kb/926628

Supported SQL Server


BTS 2013 R2BTS 2013BTS 2010BTS 2009BTS 2006 R2
SQL Server 2000NoNoNoNoYes, with SQL Server 2000 Service Pack 4
SQL Server 2000, 64-Bit EditionNoNoNoNoYes
SQL Server 2005, including 64-bitNoNoNoYes, with SQL Server 2005 Service Pack 2 or later service packYes
SQL Server 2008, including 64-bitNoNoYes, with SQL Server 2008 Service Pack 1 or later service packYesNo
SQL Server 2008 R2, including 64-bitNoYes, with SQL Server 2008 R2 Service Pack 1 or later service packYesNoNo
SQL Server 2012Yes, with SQL Server 2012 Service Pack 1YesNoNoNo
SQL Server 2014YesNoNoNoNo
SQL Server ExpressYes but not recommendedYes but not recommendedYes but not recommendedYes but not recommendedYes but not recommended

Supported Visual Studio


BTS 2013 R2BTS 2013BTS 2010BTS 2009BTS 2006 R2
Visual Studio versionVisual Studio 2013Visual Studio 2012Visual Studio 2010Visual Studio 2008 SP1 or later service packVisual Studio 2005
.NET Framework versionVisual Studio project target build: .Net Framework 4.5Visual Studio project target build: .Net Framework 4.5Visual Studio project target build: .Net Framework 4 or .Net Framework 3.5 SP1.Net Framework 3.5 SP1.Net Framework 3.0
BizTalk Runtime: .Net Framework 4.5.xBizTalk Runtime: .Net Framework 4.5.xBizTalk Runtime: .Net Framework 4.5.x (Only with CU7).Net Framework 2.0

For previous BizTalk Server versions, go to BizTalk Server: Operating System, SQL Server Version, and 64-bit Support.

1/5/16

[SftpTransmitterEndpoint] Unable to transmit file

Using SFTP adapter getting below error when processing documents for the send port,

ERROR Message: 
Microsoft.XLANGs.Core.DeliveryFailureException: Exceptions.Types.DeliveryFailureException ---> Microsoft.XLANGs.Core.XlangSoapException: An error occurred while processing the message, refer to the details section for more information Message ID: {BBE650BD-6D54-499B-8D8F-39B8F073F5EB} Instance ID: {16BD5850-9B86-4734-8AF8-1696DAE53DBD} Error Description: An unexpected failure occurred while processing a message. The text associated with the exception is "[SftpTransmitterEndpoint] Unable to transmit file /incoming/c8551288-a4a6-4861-8b25-71cd8b8e74e8. Inner Exception: Unable write file to /incoming/c8551288-a4a6-4861-8b25-71cd8b8e74e8 Unable to connect to Sftp host [hostName]. Changing any Send Port Transport properties might require the host to be restarted, as the connection pool might still have connections". --- End of inner exception stack trace --- at Microsoft.BizTalk.XLANGs.BTXEngine.ReceiveAReceipt.Execute(Segment s, Context cxt) at Microsoft.XLANGs.Core.CompositeCxtCommand.Execute(Segment s, Context ctx) at Microsoft.XLANGs.Core.Context.CleanupAndPrepareToCommit(Segment s) at GEP.BizTalk.Interfaces.Orchestrations.EPurchase_Outbound.segment4(StopConditions stopOn) at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp)

Solution: There are two solutions,

  1. Restart the mapped host instance with send port.
  2. Set 'SSH Connection Limit' property to '0' on SFTP send port configuration. By default value would be '10', set it to '0'.



1/4/16

Microsoft Integration Road-map 2016

First I want to wish Happy New Year to all my readers, friends and my sweet family. Last year 2015 I had created my first blogger and posted some article for my readers. I am frequently active on MSDN forum as well as TechNet Wiki Ninjas Facebook Page. I have learned many new things in that year. Now we have new year 2016 with more energy. 


This is my first blog in year 2016 and I hope all of my reader will enjoy to read this and will helpful for all BizTalk Techies.

There was lot of debate and frustration within the Microsoft BizTalk Server community, what is going to be Microsoft Roadmap with BizTalk and I have some forum discussion related this,
Is Biztalk Dead or Anyone has update new version of biztalk

Microsoft released the public road map that gives the holistic approach to Integration and the key product offerings that contribute to Microsoft Integration strategy. You can download the Microsoft Integration Roadmap document here https://www.microsoft.com/en-us/download/details.aspx?id=50408

We would like to highlight the following points

  • Continuing commitment to BizTalk Server, with our 10th release of BizTalk Server in Q4 2016.
  • Expansion of our iPaaS vision to provide a comprehensive and compelling integration offering spanning both traditional and modern integration requirements. Preview refresh in January 2016 and General Availability (GA) in April 2016.
  • Deliver our iPaaS offering on premises through Azure Stack in preview in Q2 2016 and GA by end of the 2016.
  • Strong roadmap and significant investments to ensure we continue to be recognized as a market leader in integration.
  • The next release of Host Integration Server is planned on the same timeline as BizTalk Server below.
BizTalk Server "2016" key planned features

  • Platform alignment – SQL 2016, Windows Server 2016, Office 2016 and latest release of Visual Studio.
  • BizTalk support for SQL 2016 AlwaysOn Availability Groups both on-premises and in Azure IaaS to provide high availability (HA).
  • HA production workloads supported in Azure IaaS.
  • Tighter integration between BizTalk Server and API connectors to enable BizTalk Server to consume our cloud connectors such as SalesForce.Com and O365 more easily.
  • Numerous enhancements including
    • Improved SFTP adapter,
    • Improved WCF NetTcpRelay adapter with SAS support
    • WCF-SAP adapter based on NCo (.NET library)
    • SHA2 support
  • Host Integration Server "2016"
    • New and improved BizTalk adapters for Informix, MQ & DB2.
    • Improvements to PowerShell integration and installation and configuration.
We are very thankful to Microsoft for this great initiative and with this roadmap one thing is sure BizTalk wasn't dead before and isn't dead now. We will be seeing a new version of BizTalk in 2016. Microsoft announced that on December 24th 2015, a few days back. Thank You Microsoft.

Stay tuned for more updates and next blog until then Happy Reading :)

About BizTalk Server Part - 2

This is next part of What is BizTalk Server blog article. Why do people still use BizTalk? In Microsoft stack, when it comes to In...