When you try to use Microsoft SQL Server Management Studio to connect to an instance of Microsoft SQL Server 2008 by using an incorrect server name, you receive the following incorrect error message:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider: Names Pipes Provider, Error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)Note
The problem in the error message is that the message incorrectly identifies SQL Server 2005 instead of SQL Server 2008. Or, an incorrect server name is identified in the error message.