BizTalk Server 2013 R2: Installation and Configuration – Configure SQL Server Network Configuration protocols (Part 10)

Posted: January 14, 2015 in BizTalk
Tags: , , , ,

This next posts will focus on installing and configuring BizTalk Server 2013 R2 and additional components

Make sure that you have installed all the latest critical Windows updates from Microsoft and all the prerequisites before you install BizTalk Server 2013 R2.

Configure SQL Server Network Configuration protocols

Under certain stress conditions (such as clients accessing SQL Server from the same computer), the SQL Server Shared Memory protocol may lower BizTalk Server performance. You can resolve this problem by disabling the use of the Shared Memory network protocol in SQL Server Network Configuration. Also, to facilitate transactions between SQL Server and BizTalk Server, you must enable TCP/IP and Named Pipes in SQL Server.

To configure the protocols for SQL Server:

  • Press the “Windows key” to switch to the Start screen, type “SQL Server Configuration Manager” and click in “SQL Server Configuration Manager” option from the Search menu.

74-BizTalk-Server-2013-R2-sql-server-2014-configuration-manager

  • In SQL Server Configuration Manager windows, from the left-hand pane expand “SQL Server Network Configuration” option and then click “Protocols for MSSQLSERVER”
    • Verify that both “TCP/IP” and “Named Pipes” are enabled;
      • If not, right-click in the protocol, and then click “Enable”
      • Repeat to enable the other protocol if necessary.
    • Verify that “Shared Memory” id Disable.
    • If not, right-click Shared Memory, and then click “Disable”

75-BizTalk-Server-2013-R2-SQL-Server-2014-configuration-manager-protocols-for-mssqlserver

  • In the left-hand pane, click “SQL Server Services”, right-click “SQL Server (MSSQLSERVER)”, and then click “Restart”. Or click “Stop” and when the service has stopped, right-click “SQL Server (MSSQLSERVER)” again, and then click “Start”.

76-BizTalk-Server-2013-R2-SQL-Server-2014-configuration-manager-sql-server-services-restart

  • Close SQL Server Configuration Manager.
Related links
Comments
  1. Rob K says:

    Sandro, all of your “Related links” are just text, not links.

    • I know Rob but thanks for the update… the goal is to update the text with the proper link as soon the post is published but unfortunately I haven’t had time to update it. They will be updated at the latest in the weekend

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s