FIX: The Shared Memory protocol for an instance of SQL Server 2008 is always enabled and the VIA protocol for the instance is always disabled after you repair the instance

Article translations Article translations
Article ID: 955769 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

After you repair an instance of Microsoft SQL Server 2008, the Shared Memory protocol for the instance is always enabled. Additionally, the VIA protocol for the instance is always disabled.

You can use several methods to run the repair operation. For example, you can repair an instance by using the Add or Remove Programs item in Control Panel.

RESOLUTION

Service pack information

To resolve this problem, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
968382 How to obtain the latest service pack for SQL Server 2008

WORKAROUND

To resolve this problem, open SQL Server Configuration Manager after you complete the repair operation. In SQL Server Configuration Manager, change the state of the Shared Memory protocol and the state of the VIA protocol to enabled or to disabled.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in SQL Server 2008 Service Pack 1.

MORE INFORMATION

The repair process tries to maintain the current state of the TCP protocol and the Named Pipes protocol.

If the repair process cannot do this because of a missing or incorrect value, the process will enable the TCP protocol and the Named Pipes protocol when it repairs a clustered SQL Server installation. This behavior occurs regardless of the edition of SQL Server. If the instance of SQL Server is not clustered, the repair process configures the state of the TCP protocol and the Named Pipes protocol according to the default values for that edition of SQL Server.

Properties

Article ID: 955769 - Last Review: April 8, 2009 - Revision: 3.0
APPLIES TO
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
Keywords: 
sql2008relnoteconnectivity sql2008relnote kbtshoot kbexpertiseadvanced kbprb KB955769

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com