SQL 2008 Install Fails on Windows 2008 x86 SP1

  • Install run up to SqlEngineDBStartConfigAction_install_configrc

    Then I got Error message:

    TITLE: Microsoft SQL Server 2008 Setup

    ------------------------------

    The following error has occurred:

    A connection was successfully established with the server, but then an error occurred during the pre-login handshake.

    (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

    Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

    detail.txt

    2010-02-09 11:35:18 Slp: Sco: Attempting to start service MSSQLSERVER

    2010-02-09 11:35:18 Slp: Sco: Attempting to open SC Manager

    2010-02-09 11:35:18 Slp: Sco: Attempting to open service handle for service MSSQLSERVER

    2010-02-09 11:35:18 Slp: Sco: Service MSSQLSERVER started

    2010-02-09 11:35:18 Slp: Sco: Attempting to close service handle for service MSSQLSERVER

    2010-02-09 11:35:18 Slp: Sco: Attempting to close SC Manager

    2010-02-09 11:35:18 Slp: Sco: Attempting to get service process id for service MSSQLSERVER

    2010-02-09 11:35:18 Slp: Sco: Attempting to open SC Manager

    2010-02-09 11:35:18 Slp: Sco: Attempting to open service handle for service MSSQLSERVER

    2010-02-09 11:35:18 Slp: Invoking QueryServiceStatusEx Win32 API

    2010-02-09 11:35:18 Slp: Sco: Attempting to close service handle for service MSSQLSERVER

    2010-02-09 11:35:18 Slp: Sco: Attempting to close SC Manager

    2010-02-09 11:35:18 Slp: Sco: Returning service process id 5456

    2010-02-09 11:35:18 SQLEngine: : Checking Engine checkpoint 'GetSqlServerProcessHandle'

    2010-02-09 11:35:18 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete' to be created

    2010-02-09 11:35:19 SQLEngine: --SqlServerServiceSCM: Waiting for nt event 'Global\sqlserverRecComplete' or sql process handle to be signaled

    2010-02-09 11:35:19 SQLEngine: : Checking Engine checkpoint 'WaitSqlServerStartEvents'

    2010-02-09 11:36:21 Slp: Sco: Attempting to initialize script

    2010-02-09 11:36:21 Slp: Sco: Attempting to initialize default connection string

    2010-02-09 11:36:21 Slp: Sco: Attempting to set script connection protocol to NotSpecified

    2010-02-09 11:36:21 Slp: Sco: Attempting to set script connection protocol to NamedPipes

    2010-02-09 11:36:21 SQLEngine: --SqlDatabaseServiceConfig: Connection String: Data Source=\\.\pipe\SQLLocal\MSSQLSERVER;Initial Catalog=master;Integrated Security=True;Pooling=False;Network Library=dbnmpntw;Application Name=SqlSetup

    2010-02-09 11:36:21 SQLEngine: : Checking Engine checkpoint 'ServiceConfigConnect'

    2010-02-09 11:36:21 SQLEngine: --SqlDatabaseServiceConfig: Connecting to SQL....

    2010-02-09 11:36:21 Slp: Sco: Attempting to connect script

    2010-02-09 11:36:21 Slp: Connection string: Data Source=\\.\pipe\SQLLocal\MSSQLSERVER;Initial Catalog=master;Integrated Security=True;Pooling=False;Network Library=dbnmpntw;Application Name=SqlSetup

    2010-02-09 11:36:21 Slp: Sco: Connection error code from SqlException is : -2146893019

    2010-02-09 11:36:21 Slp: Prompting user if they want to retry this action due to the following failure:

    2010-02-09 11:36:21 Slp: ----------------------------------------

    2010-02-09 11:36:21 Slp: The following is an exception stack listing the exceptions in outermost to innermost order

    2010-02-09 11:36:21 Slp: Inner exceptions are being indented

    2010-02-09 11:36:21 Slp:

    2010-02-09 11:36:21 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException

    2010-02-09 11:36:21 Slp: Message:

    2010-02-09 11:36:21 Slp: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

    2010-02-09 11:36:21 Slp: Data:

    2010-02-09 11:36:21 Slp: DisableRetry = true

    2010-02-09 11:36:21 Slp: Inner exception type: System.Data.SqlClient.SqlException

    2010-02-09 11:36:21 Slp: Message:

    2010-02-09 11:36:21 Slp: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

    2010-02-09 11:36:21 Slp: Data:

    2010-02-09 11:36:21 Slp: HelpLink.ProdName = Microsoft SQL Server

    2010-02-09 11:36:21 Slp: HelpLink.EvtSrc = MSSQLServer

    2010-02-09 11:36:21 Slp: HelpLink.EvtID = -2146893019

    2010-02-09 11:36:21 Slp: HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink

    2010-02-09 11:36:21 Slp: HelpLink.LinkId = 20476

    2010-02-09 11:36:21 Slp: Stack:

    2010-02-09 11:36:21 Slp: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

    2010-02-09 11:36:21 Slp: at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

    2010-02-09 11:36:21 Slp: at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable)

    2010-02-09 11:36:21 Slp: at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)

    2010-02-09 11:36:21 Slp: at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

    2010-02-09 11:36:21 Slp: at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

    2010-02-09 11:36:21 Slp: at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

    2010-02-09 11:36:21 Slp: at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

    2010-02-09 11:36:21 Slp: at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

    2010-02-09 11:36:21 Slp: at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

    2010-02-09 11:36:21 Slp: at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

    2010-02-09 11:36:21 Slp: at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

    2010-02-09 11:36:21 Slp: at System.Data.SqlClient.SqlConnection.Open()

    2010-02-09 11:36:21 Slp: at Microsoft.SqlServer.Configuration.Sco.SqlScriptExecution.GetConnection()

    2010-02-09 11:36:21 Slp: at Microsoft.SqlServer.Configuration.Sco.SqlScriptExecution.Connect()

    2010-02-09 11:36:21 Slp: ----------------------------------------

    2010-02-09 11:36:56 Slp: User has chosen to cancel this action

    2010-02-09 11:36:56 Slp: Watson Bucket 2

    Original Parameter Values

    2010-02-09 11:36:56 Slp: Parameter 0 : SQL2008@RTM@

    2010-02-09 11:36:56 Slp: Parameter 2 : System.Data.SqlClient.SqlInternalConnection.OnError

    2010-02-09 11:36:56 Slp: Parameter 3 : Microsoft.SqlServer.Configuration.Sco.ScoException@1211@1

    2010-02-09 11:36:56 Slp: Parameter 4 : System.Data.SqlClient.SqlException@-2146232060

    2010-02-09 11:36:56 Slp: Parameter 5 : SqlEngineDBStartConfigAction_install_configrc

    2010-02-09 11:36:56 Slp:

    Final Parameter Values

    2010-02-09 11:36:56 Slp: Parameter 0 : SQL2008@RTM@

    2010-02-09 11:36:56 Slp: Parameter 2 : 0x1BBF2F31

    2010-02-09 11:36:56 Slp: Parameter 3 : 0x0A2FBD17@1211@1

    2010-02-09 11:36:56 Slp: Parameter 4 : 0x3906094D

    2010-02-09 11:36:56 Slp: Parameter 5 : SqlEngineDBStartConfigAction_install_configrc

    2010-02-09 11:37:02 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100209_112022\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_

    2010-02-09 11:37:02 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100209_112022\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_

    2010-02-09 11:37:02 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100209_112022\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_

    2010-02-09 11:37:08 Slp: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

    2010-02-09 11:37:08 Slp: Watson bucket for exception based failure has been created

  • uncheck Force protocol encryption in cliconfg.exe

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply