Prerequisites
  • 02 May 2023
  • 11 Minutes to read
  • Dark
    Light
  • PDF

Prerequisites

  • Dark
    Light
  • PDF

Article Summary

This section describes which prerequisites should be met to be able to install and work with BizTalk360. This consists of the following parts:

  • What versions of BizTalk Server are supported by BizTalk360
  • What are the prerequisites for a smooth installation of BizTalk360
  • BizTalk360 Database and Memory Requirements
  • How to enable SSL / HTTPS
  • Firewall Ports and protocols required for BizTalk360
  • Enable MSDTC for BizTalk360 Stand-Alone (separate) server configuration
  • BizTalk360 supported browser versions
  • What happens when you don't provide Admin permissions to the BizTalk360 service account

What versions of BizTalk Server are supported by BizTalk360

BizTalk360 supports the following versions of BizTalk Server:

  • Microsoft BizTalk Server 2009
  • Microsoft BizTalk Server 2010
  • Microsoft BizTalk Server 2013
  • Microsoft BizTalk Server 2013 R2
  • Microsoft BizTalk Server 2016 (including Feature Packs)
  • Microsoft BizTalk Server 2020

From BizTalk360 version 8.1 onwards, if you are installing BizTalk360 on Microsoft BizTalk Server 2010 or 2009, we recommend you to install BizTalk360 in a separate machine (not on the BizTalk Server 2010 or 2009 machine).

What are the prerequisites for a smooth installation of BizTalk360

For a successful installation of BizTalk360, it is important to check whether your environment meets the following prerequisite condition:

  • Supported OS (Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019, Windows 8, Windows 8.1, and Windows 10)
  • Minimum .Net version 4.6.1 is required to BizTalk360 from version 9.1 for smooth functioning of Azure services
  • Supported BizTalk Servers – Microsoft BizTalk Server 2009, Microsoft BizTalk Server 2010, Microsoft BizTalk Server 2013, Microsoft BizTalk Server 2013 R2, Microsoft BizTalk Server 2016, Microsoft BizTalk Server 2020
  • BizTalk Admin components
  • IIS Server availability
  • URL Rewrite must be installed - BizTalk360 has upgraded from knockout JS to Angular, and users must have installed URL Rewrite extension in the environment. 
  • Administrator rights for the user
  • ASP.Net Registered
  • Windows Authentication component for IIS (7.0 and above)
  • SQL Server (any version including express is supported)
  • Make sure the user is able to connect to SQL server instance and database from the server where BizTalk360 is to be installed

Hardware Requirements

The following table shows the hardware requirements that need to be available to install BizTalk360.

ResourceRequirements
Computer and ProcessorA computer with an Intel Pentium-compatible CPU that is 1 GHz or higher for single processors. 900 MHz or higher for double processors. 700 MHz or higher for quad processors The 64-bit versions of BizTalk Server require a 64-bit operating system running on an x64 based system. Computers based on CPUs that are compatible with the AMD64 (x86-64) and Extended Memory 64-bit Technology (EM64T) processor architecture are considered x64 based systems. Hyper-Threading and Dual-Core processors are supported.
Memory8 GB or higher
Hard Disk (Database)20 GB of available hard-disk space for a complete installation including the operating system and all prerequisite software. The hard disk must be NTFS formatted.

Note: Please refer to this article when you are having more than one BizTalk Group in a BizTalk360 Instance.

Software Requirements

The following table lists the software required for installing and running BizTalk360.

Software requirementsupported versions
Operating SystemWindows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019, and Windows 10
Microsoft .NET FrameworkMinimum requirement of Microsoft .Net Framework version 4.6.1 is recommended for BizTalk360 version 10.0 and above for smooth functioning of Azure services
BizTalk ServersMicrosoft BizTalk Server 2009, Microsoft BizTalk Server 2010, Microsoft BizTalk Server 2013, Microsoft BizTalk Server 2013 R2, Microsoft BizTalk Server 2016, Microsoft BizTalk Server 2020
Internet Information Services (IIS)IIS 7.0 and above
Microsoft SQL ServersMicrosoft SQL Server 2008 onwards (Express Edition is also supported)
GeneralAdministrative rights for the user ASP.NET Registered

The BizTalk360 MSI Installer is automated to the extent of being able to detect the prerequisite connections. It will not allow you to continue further if any missing components are detected. If any errors are highlighted, you need to stop the installation process, correct the highlighted error, and then rerun the installer.

Additional Prerequisites

In addition to ensuring the above prerequisite conditions, you need to ensure the following:

Create a Service Account for BizTalk360
You need to create a service account for BizTalk360 to run the IIS Application pool and Monitoring/Analytics service. You can create a new Windows account for the service account (say, svcBizTalk360). Once you have created the service account, you need to add it to the following NT groups:

  • Local Administrators Group, this access is required on:
    • All BizTalk Servers from the licensed BizTalk360 group
    • The SQL server(s) which contain(s) the BizTalk databases
    • In case BizTalk360 is installed on a separate server(s)
    • The server(s) on which BizTalk360 is installed
  • BizTalk Server Administrators Group
  • BizTalk Application Users Group
  • BizTalk Isolated Host Users Group
  • SSO Administrators Group
  • IIS_IUSRS group

Note: You also need to make sure you make these settings across the multiple environments where you install BizTalk360. You also need to provide SQL Server SYSADMIN access to the service account. Read this to know more about the necessity to give SYSADMIN access.

Important: Please make sure that you log in to BizTalk360 server with the service account and proceed with the new installation or upgrade. This is to ensure that all permissions are in place and that you are able to log in to BizTalk360 without any issues.

To add, view, or manage users and groups, you need to follow the below steps (for Windows 2012 server):

  • Navigate to 'Computer Management' in the Windows Metro UI view
  • In the tree view, expand the 'System Tools' and 'Local Users and Groups' option

Post Installation Requirements

Grant access to BTS_ADMIN_USERS SQL Role in the BizTalk Management Database
To grant access to 'BTS_ADMIN_USERS_SQL' role (on Windows 2012 server),

  • Navigate to 'SQL Server Management Studio' in the Windows Metro UI view
  • In the Object Explorer panel, connect to SQL Server Instance and expand the tree view on the left side. Expand the SQL Server and 'Databases' and click 'BizTalkMgmtDb' database.
  • Right-click on the BizTalkMgmtDb database and select the 'New Query' option.
  • Copy and paste the following values and click 'Execute' to execute the query
  • GRANT SELECT ON dbo.adm_OtherDatabases TO BTS_ADMIN_USERS
  • GRANT SELECT ON dbo.adm_Server2HostMapping TO BTS_ADMIN_USERS
  • GRANT SELECT ON dbo.adm_ServiceClass TO BTS_ADMIN_USERS
  • GRANT SELECT ON dbo.BizTalkDbVersion TO BTS_ADMIN_USERS
  • GRANT SELECT ON dbo.adm_BackupHistory TO BTS_ADMIN_USERS

Microsoft SQL Server Authentication Modes
The SQL Server database engine has two types of authentication modes — Windows authentication mode and SQL Server and Windows Authentication mode (mixed mode). BizTalk360 supports both SQL authentication modes to connect to the SQL Server, however BizTalk360, by default, uses SQL Server and Windows authentication mode (mixed) mode.

If in case the SQL server is configured for Windows Authentication mode, you will see an error when you launch the application for the first time:

Default BizTalk360 installation creates and uses a SQL server for authentication
Make sure either both Windows and SQL authentication is enabled on the SQL instance, where BizTalk360 database is hosted, or Change the config files (web.config and monitoring service.config) to use Windows Authentication.
If you still want to use Windows Authentication mode, you need to make changes to BizTalk360ConnectionString in the web.config in the BizTalk360 Web Installation folder:

  • You will find the Web.config file in the BizTalk360 Web Installation folder (C:\Program Files (x86)\Kovai Ltd\BizTalk360\Web)

To use Windows authentication mode, change the above connection strings by uncommenting (removing ) the first line and commenting the second line (adding )

In addition to making the changes to BizTalk360ConnectionString in web.config file, you need to make the changes in BizTalk360.monitor.exe.config file in the BizTalk360 Service Installation folder. To change the security SQL server authentication mode:

  • In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties
  • On the Security page, under Server authentication, select the new server authentication mode, and then click OK

BizTalk360-Prerequisites-SQL-Server-Properties.png

  • In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server
  • In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted, Post BizTalk360 installation, a user profile has to be created for the Service account with Super User access privileges. Only then, BizTalk360 can perform operation automation capabilities (such as Resume/Suspend/Terminate) in the Message Box data monitor.

BizTalk360 Database And Memory Requirements

Database Requirements

We recommend you start off by provisioning 10 GB for this purpose. The reason for this is that there are 2 features in BizTalk360 - Advanced Event Viewer and Throttling Analyzer that will cause the database to grow in size since they collect the data and persist the information. If the purge policy in BizTalk360 is set to the default values and you do not have too many hosts and host instances, then a database size of 10 GB should be sufficient.

Memory Requirements

If you are installing BizTalk360 on a standalone server, we recommend you to have a memory of 8 GB or higher to serve the purpose.

How To Enable SSL / HTTPS

Steps To Enable SSL / HTTPS For BizTalk360

In order to deploy BizTalk360 on HTTPS, your IIS must be enabled for HTTPS/SSL. The below links explain how to set up SSL on IIS 7. Please consult your IIS administrator before changing anything in your IIS as it may affect other critical sites running on that IIS.

IIS 7: https://www.iis.net/learn/manage/configuring-security/how-to-set-up-ssl-on-iis

Once you have set up SSL on your IIS, you will need to enable HTTPS for BizTalk360. Follow the steps as shown below:

  • Open Web.config from \Kovai Ltd\BizTalk360\Web
  • Change security mode for basicHttpBinding (refer to the screenshot below)
  • Change security mode for webHttpBinding (refer to the screenshot below)
  • Enable HTTPS for serviceMetaData (refer to the screenshot below)
  • The above steps will disable HTTP and enable HTTPS for BizTalk360. Depending on your IIS version and setup, you may need to reset IIS or recycle AppPool. Please consult your IIS administrator for more information.

What & Where To Change In Web.config

-BizTalk360-Prerequisites-Enable-SSL.png

Once after the change

-BizTalk360-Prerequisites-Enable-SSL-After-The-Change.png

Firewall Ports And Protocols Required for BizTalk360

BizTalk360 basically requires the same configuration as BizTalk Server Administration. For a complete list of ports utilized by BizTalk Server as admin server, please use the below link:

https://docs.microsoft.com/en-us/biztalk/core/ports-for-the-administration-server

Basically, you need to have SQL, WMI, DTC, IIS destination services configured.

Enable MSDTC For BizTalk360 Stand-Alone (Separate) Server Configuration

Configuring MSDTC is key in multi-server BizTalk server environment configuration. Typically the following procedure should be followed in all BizTalk servers in a multi-server environment. When you are installing BizTalk360 on a stand-alone (separate) server, you need to follow the exact procedures, since the underlying admin APIs will rely on MSDTC.

To enable MSDTC on Windows Server 2008 and above:

  • Click Start, click Run, type dcomcnfg and then click OK to open Component Services
  • In the console tree, click to expand Component Services, click to expand Computers, click to expand My Computer, and click to expand Distributed Transaction Coordinator
  • Right-click Local DTC, and click Properties to display the Local DTC Properties dialog box
  • Click the Security tab
  • In the Security Settings section, click Network DTC Access
  • In the Client and Administration section, select Allow Remote Clients and Allow Remote Administration
  • In the Transaction Manager Communication section, select Allow Inbound and Allow Outbound
  • In the Transaction Manager Communication section, select Mutual Authentication Required (if all remote machines are running Windows Server 2003 SP1 or Windows XP SP2 or higher), select Incoming Caller Authentication Required (if running MSDTC in a cluster), or select No Authentication Required if some of the remote machines are pre-Windows Server 2003 SP1 or pre-Windows XP SP2. No Authentication Required is the recommended selection
  • Select Enable XA Transactions, and then click OK

BizTalk360-Prerequisites-MSDTC-Settings.png

If you experience any MSDTC issues, you can use DTCPing.exe to validate the connection between the BizTalk360 server and server in the remote BizTalk environment. To obtain the DTCPing.exe tool, see https://go.microsoft.com/fwlink/?LinkId=72166.

BizTalk360 Supported Browser Versions

We have tested BizTalk360 against the following browser versions. We also support other browser versions with the best effort.

  • Google Chrome - 91.0.4472.106 and later
  • Firefox - 88.0.1 and later
  • Microsoft Edge - 91.0.864.48 and later

What happens when you don't provide Admin permissions to the BizTalk360 service account

The service account will have powerful access, but all other users who access BizTalk360 will have very limited access, they don't even need to belong to any BizTalk groups, BizTalk360 abstracts all the security requirements.

BizTalk360 service account user without Local (Windows) Admin permission

BizTalk360 installation will not be proceeded using the service account user privileges.Service account should have local (Windows) admin privileges in all the servers (BizTalk Server, SQL Server).

Considerations while installing BizTalk360: Login to the machine with the service account which has Local Admin privileges. Open a command prompt with Admin privileges and navigate to the downloaded BizTalk360.msi file to proceed with the installation

Note: If the BizTalk360 installation is started with no admin privileges it will encounter the runtime access issue

If the service account is not been provided with the local admin privilege, the following functionalities will not work as expected:

  • In the Advanced Event Viewer, only the installed machine details were fetched
  • BizTalk Server and SQL server system-related details will not be displayed under Operations, BizTalk360 UI -> Operations -> Infrastructure Settings -> BizTalk Services/SQL Services. It will just spin for a long time
  • BizTalk Server and SQL server system related details will not be displayed and exceptions will be thrown under BizTalk360 UI -> Monitoring -> Manage Mapping -> BizTalkServers/SQLServers
  • File monitoring will become “Orphaned” if you configure

BizTalk360-Prerequisites-File-Monitoring.png

Analytics will work partially; for some of the counters, details are fetched from the database directly; another system-related information like CPU, Available Memory will not be shown as it requires elevated permissions

BizTalk360 service account user without SYSADMIN permission

When the BizTalk360 service account (domain user account) doesn’t have SYSADMIN privileges on the BizTalk360 Database, you will not able to open the BizTalk360 web page, it will throw a login failed exception

-BizTalk360-Prerequisites-Cannot-Open-Database-Exception.png

To solve this, the user must be provided "db_owner" permission or SYSADMIN access in the BizTalk360 Database security.

When the BizTalk360 service account (domain user account) doesn’t have Sysadmin privileges on the BizTalk Database (BizTalkMgmtDb), you might face the below exception during the activation of the license.

BizTalk360-Prerequisites-Cannot-Open-Database-Exception2.png

BizTalk360 makes a direct query to some of the BizTalk databases for performance reasons. For that, you need to provide SELECT/EXECUTE permission for the BizTalk360 service account.

Adapter Pack

When you attempt to enable/disable a receive location that uses the WCF-SQL adapter, or when you attempt to start/stop a send port, you may experience this error "Failed to create 'WCF-SQL' Transport Component".

Once after installing BizTalk360, install the BizTalk Server Enterprise Adapter Pack in the server where BizTalk360 is installed.

If you are using any 3rd party adapters like nSoftware, you have to install the nSoftware Adapter Pack as well on the server where BizTalk360 is installed.

Our recommendation

Some of our customers hesitate to provide higher-level permissions like Local Admin and System Admin due to security reasons. So we recommend creating a separate account for the BizTalk360 service and provide all the necessary permissions to isolate the credentials.


Was this article helpful?

ESC

Eddy, a super-smart generative AI, opening up ways to have tailored queries and responses