AUTHOR - .NET Framework

WHITEPAPER

AUTHOR

LEX HEGT

MARK

BRIMBLE

2

Contents

1

About the Author.................................................................................................................. 5

2

BizTalk Server Installation scenario ................................................................................... 5

Assumptions and out of scope ............................................................................................................ 6

3

Important considerations before setting up the server ................................................ 6

Join the Local Administrators Group ................................................................................................. 6

Turn off Internet Explorer Enhanced Security Configuration (optional) .................................... 8

Disable User Account Control (optional) .......................................................................................... 9

Turn Windows Firewall off (optional) .............................................................................................. 11

Configure the Application Event Log ............................................................................................... 12

Configure Microsoft Distributed Transaction Coordinator (MS DTC) ...................................... 14

Customize Taskbar and Start Menu Properties (optional) ........................................................... 15

Set the default browser (Optional) ................................................................................................... 17

Disable Windows Defender (Optional) ........................................................................................... 19

Install Critical Windows Updates ..................................................................................................... 20

4

Preparing and install prerequisites for BizTalk Server 2016..................................... 22

Important considerations before set up the server ...................................................................... 22

Enable Internet Information Services .............................................................................................. 22

Running the BAM Portal in a 64-bit Environment .................................................................... 28

Install Windows Identity Foundation (WIF) ................................................................................... 29

Install and configure SMTP Server Feature (optional).................................................................. 31

Verify Your Installation ....................................................................................................................... 36

Install Microsoft Office Excel 2016 ................................................................................................. 37

Installing and configuring Office 2016 Deployment Tool ....................................................... 38

Installing Microsoft Office Excel 2016 ............................................................................................ 39

Install Visual Studio 2015................................................................................................................... 41

Remove Microsoft SQL Server Express .......................................................................................... 44

Install SQL Server 2016 ...................................................................................................................... 45

Configure SQL Server Database Mail feature................................................................................ 57

Install BizTalk Server 2016 ................................................................................................................ 64

Verify Your Installation ....................................................................................................................... 68

Configure BizTalk Server .................................................................................................................... 69

Pin BizTalk Server Administration to taskbar ............................................................................ 72

Configure SQL Server Network Configuration protocols ........................................................... 74

3

Validate Mail account used by BizTalk to send BAM Alerts ....................................................... 75

Install BizTalk Adapter Pack .............................................................................................................. 77

Microsoft BizTalk Adapter Pack and Microsoft BizTalk Adapter Pack (x64) ...................... 78

Steps to install BizTalk Adapter Pack .......................................................................................... 78

Add adapters to BizTalk Administration Console ..................................................................... 90

Install Critical Windows Updates and BizTalk Server Cumulative Update Package .............. 92

Configure BizTalk Server SQL Jobs.................................................................................................. 92

How to configure Backup BizTalk Server (BizTalkMgmtDb) .................................................. 93

How to configure DTA Purge and Archive (BizTalkDTADb) .................................................. 97

MessageBox_Message_Cleanup_BizTalkMsgBoxDb ............................................................... 99

5

Optimize the BizTalk Server 2016 environment ....................................................... 100

Deleting BizTalk backup files ......................................................................................................... 100

Implementing a custom sp_DeleteBackupHistory ................................................................. 100

Implementing a Maintenance Plan to clean BizTalk Database backup¡¯s files .................. 101

Pre-allocate space and define auto-growth settings for BizTalk Server databases ............ 106

Configure BizTalk Server Windows Services .............................................................................. 110

Install and configure BizTalk Health Monitor ............................................................................. 113

How to install BizTalk Health Monitor Snap-In ...................................................................... 113

How to integrate BHM Snap-In into BizTalk Admin Console ............................................. 114

Install SSO Configuration Application MMC Snap-In (Optional) ............................................ 117

Installing WinSCP (Optional) .......................................................................................................... 119

Configure BizTalk Jobs History (Microsoft SQL Server Agent job history log) .................... 122

To resize the job history log based on raw size ...................................................................... 123

To resize the job history log based on time............................................................................. 123

Managing and cleaning BizTalk Server MarkLog database tables .......................................... 124

Configure Host and Host instances .............................................................................................. 128

What are Host, Host Instances and Adapter Handlers? ....................................................... 129

Best practices to Configuring Hosts and Host Instances ..................................................... 130

Power Mode ...................................................................................................................................... 132

Consider setting the 'text in row' table option to boost BizTalk Server Performance

(optional) ............................................................................................................................................. 133

How to exploit the Text in Row table option in BizTalk Server .......................................... 133

6

Appendix A: Hardware and Software Requirements ............................................... 135

Hardware Requirements ................................................................................................................. 135

Software Requirements ................................................................................................................... 135

4

7

Appendix B: Redistributable CAB Files ....................................................................... 138

List of Redistributable CAB Files for BizTalk Server 2016 ....................................................... 139

8

Appendix C: Basic Configuration vs. Custom Configuration .................................. 139

5

1

About the Author

Sandro Pereira [Microsoft Integration MVP]

Sandro Pereira lives in Portugal and works as a consultant at DevScope

(). In the past years, he has been working on implementing

Integration scenarios both on-premises and cloud for various clients, each

with different scenarios from a technical point of view, size, and criticality,

using Microsoft Azure, Microsoft BizTalk Server and different technologies

like AS2, EDI, RosettaNet, SAP, TIBCO etc.

He is a regular blogger (), international speaker,

and technical reviewer of several BizTalk books all focused on Integration. He is also the author

of the book ¡°BizTalk Mapping Patterns & Best Practices¡±. He has been awarded MVP since

2011 for his contributions to the integration community.

You can contact Sandro at: sandro-pereira@.pt (Twitter: @sandro_asp).

2

BizTalk Server Installation scenario

This article will explain in detail ¨C a step-by-step guideline - how to install and configure

Microsoft BizTalk Server 2016 on a standalone environment running Windows Server 2016.

This information will help you plan the installation and configuration of BizTalk Server 2016,

applications and components on which it depends focused on creating a development

environment (you can also follow this tutorial to help you create production environments,

however if this is the case you need to skip some steps).

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download