none
BTS 2016 licensing

    General discussion

  • Proposed BTS configuration

    Dedicated server instance on non-virtualized clustered MSSQL
    Single standalone virtualized BTS 2016 server

    Possible issues:

    • Disable IPV6
    • Enable TCP/IP and Named Pipes
    • Disable shared memory protocol in SQL server 
    • Needed changes in the registry, eg disable the SYN flooding attack protection 


    Licensing: 
    I assume BizTalk Standard is valid as in a two server configuration?

    Any thoughts?
    My preference is a dedicated MSSQL server, current two server production setup is virtualized

    Thanks in advance /Peter


    • Edited by Peter Lykkegaard Thursday, August 31, 2017 7:59 AM Changed formatting
    Thursday, August 31, 2017 7:58 AM

All replies

  • Dedicated SQL Instance(s) for BizTalk, yes.

    Single BizTalk 2016 VM, sure...

    Disable IPV6, yes.

    Enable TCP/IP only.  No Named Pipes or Shared Memory.  Client and server since you own that instance.

    SYN attack...I think that was a pre Windows Server 2012 thing...hasn't come up at all lately.

    Yes, BizTalk Server Standard Edition supports a remote SQL Server.

    Maybe setup MSDTC to the most restrictive settings that work.

    Thursday, August 31, 2017 1:36 PM
    Moderator
  • Thanks /Peter
    Friday, September 01, 2017 11:53 AM
  • It might be a nice idea on paper, but make sure to check server stats before even considering such a move

    IO latency is not the best atm, an idea could be to run active/active/passive with 3 nodes but you must move from SQL Server Standard License (2 node cluster) to Enterprise license to have multiple nodes

    /Peter

    Saturday, September 09, 2017 9:31 PM