Post-installation Steps for BizTalk Server 2013 and 2013 R2

Enable TCP/IP and Named Pipes

Open SQL Server Configuration Manager.
Expand SQL Server Network Configuration, and select Protocols for MSSQLSERVER.
Verify that both TCP/IP and Named Pipes are enabled. If enabled, proceed to the next step.

If not enabled:
- Right-click the protocol, and then click Enable.
- Repeat to enable the other protocol if necessary.
- In the left-hand pane, click SQL Server Services.
- In the right-hand pane, right-click SQL Server (MSSQLSERVER), and click Stop.
- When the service has stopped, right-click SQL Server (MSSQLSERVER), and click Start.
Important

If you are using SQL Server 2008 R2, the NS$BAMAlerts service may be stopped. Restart the service.
Close the Configuration Manager.

Open Component Services:
- Windows Server 2012 : Select the Windows button, and type Component Services. In the Results window, select Component Services.
- Windows 8.1: Select the Windows button, and type Administrative Tools. In the Search window, select Settings. In the Results window, click Administrative Tools. Double-click Component Services.
- Windows 7 SP1: Select Start. In the Search text box, type Component Services, and click it to open.
In the console tree, expand Component Services, expand Computers, expand My Computer, expand Distributed Transaction Coordinator, and then click Local DTC.
Right-click Local DTC and select Properties to open the Local DTC Properties.
Select the Security tab.
Confirm the following options are checked:
- Network DTC Access
- Allow Inbound
- Allow Outbound
- No Authentication Required
For additional settings that may be needed, see Troubleshooting Problems with MSDTC.
Select OK to close the Local DTC Properties dialog box. Restart the MSDTC service if prompted.
Close Component Services.

Open Windows Firewall:
- Windows Server 2012 : Click the Windows button, and type Windows Firewall. In the Results window, click Windows Firewall.
- Windows 8.1: Click the Windows button, and type Windows Firewall. In the Search window, click Settings. In the Results window, click Windows Firewall.
- Windows 7 SP1: Click Start. In the Search text box, type Windows Firewall, and click it to open.
Click Advanced Settings and click Inbound Rules.
In the Inbound Rules pane, right-click Distributed Transaction Coordinator * (as appropriate), and then click Enable Rule.
Click Outbound Rules.
In the Outbound Rules pane, right-click Distributed Transaction Coordinator * (as appropriate), and then click Enable Rule.
On the Control Panel, change the view to list by icons, and then double-click Administrative Tools.
Double-click Services.
Right-click COM+ System Application, click Restart, and wait for the service to restart.
Right-click and restart the Distributed Transaction Coordinator service.
Right-click and restart the SQL Server (MSSQLSERVER) service.
Close Services (Local), and then close Administrative Tools.

Backup BizTalk Server: This SQL Agent job backs up the BizTalk Server databases and the log files. When configuring the job, you determine parameters like frequency and file location.

The following links describe the SQL Agent job and its parameters:
- Backing Up and Restoring BizTalk Server Databases
- Configure the Backup BizTalk Server Job
This SQL Agent job also truncates the transaction logs, which helps improve performance. The Backup BizTalk Server job may not remove or delete backup files, including older files.
DTA Purge and Archive: This SQL Agent job truncates and archives the BizTalk Server Tracking database (BizTalkDTADb). When configuring the job, you determine parameters like how many days to keep completed instances and how many to days to keep all data.

The following links describe the SQL Agent job and its parameters:
- Archive and Purge the BizTalkDTADb Database
- Configure the DTA Purge and Archive Job
This SQL Agent job directly impacts performance by maintaining the Tracking host and purging tracking events. Performance topics include:
- How to maintain and troubleshoot BizTalk Server databases
- Tracking Database Sizing Guidelines
When BizTalk Server is installed, several SQL Agent jobs are automatically created, as described in the following links:
- Description of the SQL Server Agent jobs in BizTalk Server
- Database Structure and Jobs

After you install BizTalk Server, install any BizTalk Server cumulative updates listed in Windows Update. For more information, go to Service Pack and cumulative update list for BizTalk Server.