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 theAdd or Remove Programs item in Control Panel.
Resolution
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:
968382?(http://support.microsoft.com/kb/968382/) How to obtain the latest service pack for SQL Server 2008