Export (0) Print
Expand All

Post-installation Steps for BizTalk Server 2013 and 2013 R2

[Unless specifically noted, the content in this topic applies to BizTalk Server 2013 and 2013 R2.]

Perform the tasks in this topic after you have installed BizTalk Server. Steps include:

Enable TCP/IP and Named Pipes

Enable DTC on the Local Host Server

Configure Windows Firewall to Enable DTC

Configure SQL Agent Jobs

Install Cumulative Updates

Enable TCP/IP and Named Pipes

  1. Open SQL Server Configuration Manager.

  2. In the left-hand pane, expand SQL Server Network Configuration.

  3. Select Protocols for MSSQLSERVER.

  4. 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.

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

  5. Close the Configuration Manager.

Enable DTC on the Local Host Server

  1. Open Component Services:

    Windows Server 2012 : Select the Windows button on the keyboard and type Component Services. In the Results window, select Component Services.

    Windows 8.1: Select the Windows button on the keyboard 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.

  2. In the console tree, expand Component Services, expand Computers, expand My Computer, expand Distributed Transaction Coordinator, and then click Local DTC.

  3. Right-click Local DTC and select Properties to open the Local DTC Properties.

  4. Select the Security tab.

  5. 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.

  6. Select OK to close the Local DTC Properties dialog box. If prompted to restart the MSDTC service, click Yes.

  7. Close Component Services.

Configure Windows Firewall to Enable DTC

  1. Open Windows Firewall:

    Windows Server 2012 : Click the Windows button on the keyboard and type Windows Firewall. In the Results window, click Windows Firewall.

    Windows 8.1: Click the Windows button on the keyboard 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.

  2. Click Advanced Settings and click Inbound Rules.

  3. In the Inbound Rules pane, right-click Distributed Transaction Coordinator * (as appropriate), and then click Enable Rule.

  4. Click Outbound Rules.

  5. In the Outbound Rules pane, right-click Distributed Transaction Coordinator * (as appropriate), and then click Enable Rule.

  6. On the Control Panel, change the view to list by icons, and then double-click Administrative Tools.

  7. Double-click Services.

  8. Right-click COM+ System Application, click Restart, and wait for the service to restart.

  9. Right-click and restart the Distributed Transaction Coordinator service.

  10. Right-click and restart the SQL Server (MSSQLSERVER) service.

  11. Close Services (Local), and then close Administrative Tools.

Configure SQL Agent Jobs

 

Job Description Why configure

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

How to Configure the Backup BizTalk Server Job

This SQL Agent job also truncates the transaction logs, which helps improve performance.

The Backup BizTalk Server job does not remove or delete backup files, including older files. To delete backup files, refer to The "Backup BizTalk Server" job fails when backup files accumulate over time in the Microsoft BizTalk Server database server.

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:

Archiving and Purging the BizTalk Tracking Database

How to 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

Additional

Install Cumulative Updates

After you install BizTalk Server, install any BizTalk Server cumulative updates listed in Windows Update. KB article 2555976 lists available service packs and cumulative updates.

Next

See Also

© 2014 Microsoft Corporation. All rights reserved.

Community Additions

ADD
Show:
© 2014 Microsoft