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

Posted: May 19, 2013 in BizTalk
Tags: , , ,

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 Metro UI and type “SQL Server Configuration Manager” and click in “SQL Server Configuration Manager” option on Apps menu.

BTS-2013-SQLNet-01-SQL-Server-Configuration-Manager-metro-UI

  • 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”

BTS-2013-SQLNet-02-SQL-Server-Configuration-Manager-Protocols-for-MSSQLSERVER

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

BTS-2013-SQLNet-03-SQL-Server-Configuration-Manager-SQL-Server-Services-restart

  • Close SQL Server Configuration Manager.

Related links

Comments
  1. Sandro,

    As always, you provide very valuable information. My current client is implementing BTS 2013 and your series has been very helpfully

  2. yassin says:

    tnx for this informations Sandro

  3. Leon Broeks says:

    Thnx! Sandro

    Very userfull !

  4. […] BizTalk 2013 Installation and Configuration – Configure SQL Server Network Configuration protocols… […]

  5. […] BizTalk 2013 Installation and Configuration – Configure SQL Server Network Configuration protocols… […]

  6. […] BizTalk 2013 Installation and Configuration – Configure SQL Server Network Configuration protocols… […]

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