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
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.
Service pack informationTo 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:
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.
Article ID: 955769 - Last Review: 04/08/2009 00:07:18 - Revision: 3.0
- sql2008relnoteconnectivity sql2008relnote kbtshoot kbexpertiseadvanced kbprb KB955769