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

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.
內容

文章識別碼:955829 - 最後檢閱時間:2010年5月14日 - 修訂: 1

意見反應