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.
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
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.
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.
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.