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.
ID d'article : 955769 - Dernière mise à jour : 7 avr. 2009 - Révision : 1