You receive a SQL Server 2005 connection failure error message when you try to connect to an instance of SQL Server 2008 in SQL Server Management Studio

Article translations Article translations
Article ID: 955638 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

For information about Microsoft SQL Server Management Studio, visit the following Microsoft Web site:
http://www.microsoft.com/sqlserver/2008/en/us/manageability.aspx

Properties

Article ID: 955638 - Last Review: March 19, 2009 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2008 Workgroup
Keywords: 
sql2008relnotetools sql2008relnote kbtshoot kberrmsg kbexpertiseinter kbprb KB955638

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com