Install BizTalk Server 2006 R2 on Windows XP or Windows Server 2003 – Part 5: Configuring Microsoft SQL Server 2005

By: Editor
April 24, 2009

This article is a part of a series describing the Installation of BizTalk Server 2006 R2 on Windows XP or Windows Server 2003.

Configuring Microsoft SQL Server 2005

Microsoft recommends disabling Shared Memory protocol on SQL Server 2005 as this will degrade the performance when both BizTalk and SQL Server are running in parallel. Follow the below mentioned steps to disable the Shared Memory protocol.

Follow the below mentioned steps to configure SQL Server 2005:

1. Click Start | All Programs | Microsoft SQL Server 2005 | Configuration Tools | SQL Server Configuration Manager.

2. In SQL Server Configuration Manger expand the SQL Server 2005 Network Configuration node and then click on the protocols node to bring up all the available protocol information in the right panel as shown in the below snippet.

    SQL Server Configuration Manager

3. Right click Shared Memory Protocol and select the status as Disabled.


4. Close the SQL Server Configuration Manger and recycle the MSSQLSERVER service.

In Part 6, we'll take a look at how to Install BizTalk Server 2006 R2.


Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article


Previous Page.. Next Page..


Geeks who read this article also read…




Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."