The installation process of SQL Server 2008 or of SQL Server 2008 R2 may fail if the server alias is defined in the Client Network Utility

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

SYMPTOMS

When you try to install Microsoft SQL Server 2008 or SQL Server 2008 R2 , the installation process may fail. Additionally, the following error may be written to the setup log:
DateTime Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
DateTime Slp Slp: Microsoft.SqlServer.Configuration.Sco.ScoException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server Version,, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
This problem occurs if you have defined a server alias in the Client Network Utility for a protocol other than Shared Memory.

CAUSE

This problem occurs because the user-defined server alias does not allow for shared memory connections.

RESOLUTION

To resolve this problem, follow these steps:
  1. Click Start, click Run, type cliconfg, and then click OK.
  2. In the SQL Server Client Network Utility dialog box, click the Alias tab.
  3. Select the server alias that you created, and then click Remove.
  4. Uninstall the partly installed SQL Server 2008 installation.
  5. Install SQL Server 2008 again.

STATUS

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

Properties

Article ID: 955829 - Last Review: March 19, 2009 - Revision: 3.1
APPLIES TO
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
Keywords: 
sql2008relnotedatabaseengine sql2008relnote kbtshoot kbprb kberrmsg KB955829

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