none
SQL Server 2016 installation fails: Microsoft.SqlServer.Configuration.Sco.ScoException Arithmetic operation resulted in an overflow

    Question

  • I've been trying repeatedly to install the SQL Server 2016 Developer Edition on Windows 10. Every time the database engine fails to install and pops up a message "Object reference not set to an instance of an object". Then the installer crashes. The database services seem to be running but you can't connect to them.

    I've attempted uninstalling and reinstalling every Microsoft program related to SQL Server, .NET or Visual C++ on the PC. I've run setup.exe as an Administrator. I've tried changing all the services to use the System account. Don't know what else to try.

    Looking in the logs reveals the following exception:


    Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
    Message:
    Arithmetic operation resulted in an overflow.
    HResult : 0x84bb0001
    FacilityCode : 1211 (4bb)
    ErrorCode : 1 (0001)
    Data:
    DisableRetry = true
    Inner exception type: System.OverflowException
    Message:
    Arithmetic operation resulted in an overflow.
    HResult : 0x80131516
    Stack:
    at SNIOpenSyncExWrapper(SNI_CLIENT_CONSUMER_INFO* , SNI_ConnWrapper** )
    at SNINativeMethodWrapper.SNIOpenSyncEx(ConsumerInfo consumerInfo, String constring, IntPtr& pConn, Byte[] spnBuffer, Byte[] instanceName, Boolean fOverrideCache, Boolean fSync, Int32 timeout, Boolean fParallel, Int32 transparentNetworkResolutionStateNo, Int32 totalTimeout)
    at System.Data.SqlClient.SNIHandle..ctor(ConsumerInfo myInfo, String serverName, Byte[] spnBuffer, Boolean ignoreSniOpenTimeout, Int32 timeout, Byte[]& instanceName, Boolean flushCache, Boolean fSync, Boolean fParallel, TransparentNetworkResolutionState transparentNetworkResolutionState, Int32 totalTimeout)
    at System.Data.SqlClient.TdsParserStateObject.CreatePhysicalSNIHandle(String serverName, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Byte[]& instanceName, Byte[] spnBuffer, Boolean flushCache, Boolean async, Boolean fParallel, TransparentNetworkResolutionState transparentNetworkResolutionState, Int32 totalTimeout)
    at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, Boolean isFirstTransparentAttempt, SqlAuthenticationMethod authType)
    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover, Boolean isFirstTransparentAttempt)
    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
    at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
    at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
    at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
    at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
    at System.Data.SqlClient.SqlConnection.Open()
    at Microsoft.SqlServer.Configuration.Sco.SqlScriptExecution.GetConnection()
    at Microsoft.SqlServer.Configuration.Sco.SqlScriptExecution.Connect()

    Followed soon by this exception:

    Exception type: System.NullReferenceException
    Message:
    Object reference not set to an instance of an object.
    HResult : 0x80004003
    Data:
    SQL.Setup.FailureCategory = ConfigurationFailure
    WatsonConfigActionData = INSTALL@CONFIGRC@SQL_ENGINE_CORE_INST
    WatsonExceptionFeatureIdsActionData = System.String[]
    Stack:
    at Microsoft.SqlServer.Chainer.Infrastructure.WatsonExceptionBucket.FormatStackFrame(StackFrame stackFrame)
    at Microsoft.SqlServer.Chainer.Infrastructure.WatsonExceptionBucket.DetermineBucketParams()
    at Microsoft.SqlServer.Configuration.UIExtension.RegisterRetryHandlerAction.RetryPromptHandler(AcceptedEventResults acceptedResults, Object notification, Object[] objectArray)
    at Microsoft.SqlServer.Chainer.Infrastructure.ChainerRetryResponse.InvokeRetry(ServiceContainer context, Exception e)
    at Microsoft.SqlServer.Configuration.Sco.SqlScriptExecution.Connect()
    at Microsoft.SqlServer.Configuration.SqlEngine.SqlDatabaseServiceConfig.Install(SqlServiceInstallScriptParameters scriptParameters, Boolean fTemplateDB)
    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.ConfigSQLServerSystemDatabases(EffectiveProperties properties, Boolean isConfiguringTemplateDBs, Boolean useInstallInputs)
    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.DoCommonDBStartConfig(ConfigActionTiming timing)
    at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)
    at Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
    at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)
    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
    at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
    Watson Bucket 2
    Original Parameter Values

    There are also some messages like this:

    Slp: Sco: Attempting to get account sid for user account NT Service\SQLSERVERAGENT
    Slp: Sco: Attempting to get sid for user account NT Service\SQLSERVERAGENT
    Slp: Sco: Failed when querying buffer size

    Wednesday, December 7, 2016 10:49 AM

Answers

All replies

  • That message looks unpleasantly similar to one of the dumps in this thread:
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/836d650c-5d68-4b40-a8c4-41d09ea67fd6/sql-server-2016-wait-on-the-database-engine-now-object-reference-not-set-to-an-instance-of-an?forum=sqlsetupandupgrade#97029dcb-b4ef-4221-beab-c57479ce87d6

    The poor guy closed the loop earlier today by saying that he reformated his disk and reinstalled. Apparently this was not the only problem he had encountered since he had been forced to upgrade to Windows 10. Do you by chance also have a Win 10 that originally was a lower version of Windows?

    • Proposed as answer by Naomi NModerator Thursday, December 8, 2016 10:20 AM
    • Marked as answer by Gary Jacobson Thursday, December 8, 2016 10:21 AM
    Wednesday, December 7, 2016 10:43 PM
  • Yes, it was an upgrade from Windows 7. I've also reluctantly reached the conclusion that it's time to reinstall Windows.
    Thursday, December 8, 2016 9:12 AM
  • I have the same issue tyring to install SQL 2016 Developer Edition.

    Fails on the edition with and without Service Pack 1.

    Error:

    (01) 2017-01-05 10:10:46 SQLEngine: --SqlDatabaseServiceConfig: Connection String: Data Source=\\.\pipe\SQLLocal\MSSQLSERVER;Initial Catalog=master;Integrated Security=True;Pooling=False;Connect Timeout=300;Network Library=dbnmpntw;Application Name=SqlSetup
    (01) 2017-01-05 10:10:46 SQLEngine: : Checking Engine checkpoint 'ServiceConfigConnect'
    (01) 2017-01-05 10:10:46 SQLEngine: --SqlDatabaseServiceConfig: Connecting to SQL....
    (01) 2017-01-05 10:10:46 Slp: Sco: Attempting to connect script
    (01) 2017-01-05 10:10:46 Slp: Connection string: Data Source=\\.\pipe\SQLLocal\MSSQLSERVER;Initial Catalog=master;Integrated Security=True;Pooling=False;Connect Timeout=300;Network Library=dbnmpntw;Application Name=SqlSetup
    (01) 2017-01-05 10:10:46 Slp: Prompting user if they want to retry this action due to the following failure:
    (01) 2017-01-05 10:10:46 Slp: ----------------------------------------
    (01) 2017-01-05 10:10:46 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    (01) 2017-01-05 10:10:46 Slp: Inner exceptions are being indented
    (01) 2017-01-05 10:10:46 Slp: 
    (01) 2017-01-05 10:10:46 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
    (01) 2017-01-05 10:10:46 Slp:     Message: 
    (01) 2017-01-05 10:10:46 Slp:         Arithmetic operation resulted in an overflow.
    (01) 2017-01-05 10:10:46 Slp:     HResult : 0x84bb0001
    (01) 2017-01-05 10:10:46 Slp:         FacilityCode : 1211 (4bb)
    (01) 2017-01-05 10:10:46 Slp:         ErrorCode : 1 (0001)
    (01) 2017-01-05 10:10:46 Slp:     Data: 
    (01) 2017-01-05 10:10:46 Slp:       DisableRetry = true
    (01) 2017-01-05 10:10:46 Slp:     Inner exception type: System.OverflowException
    (01) 2017-01-05 10:10:46 Slp:         Message: 
    (01) 2017-01-05 10:10:46 Slp:                 Arithmetic operation resulted in an overflow.
    (01) 2017-01-05 10:10:46 Slp:         HResult : 0x80131516
    (01) 2017-01-05 10:10:46 Slp:         Stack: 
    (01) 2017-01-05 10:10:46 Slp:                 at SNIOpenSyncExWrapper(SNI_CLIENT_CONSUMER_INFO* , SNI_ConnWrapper** )
    (01) 2017-01-05 10:10:46 Slp:                 at SNINativeMethodWrapper.SNIOpenSyncEx(ConsumerInfo consumerInfo, String constring, IntPtr& pConn, Byte[] spnBuffer, Byte[] instanceName, Boolean fOverrideCache, Boolean fSync, Int32 timeout, Boolean fParallel, Int32 transparentNetworkResolutionStateNo, Int32 totalTimeout)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.SNIHandle..ctor(ConsumerInfo myInfo, String serverName, Byte[] spnBuffer, Boolean ignoreSniOpenTimeout, Int32 timeout, Byte[]& instanceName, Boolean flushCache, Boolean fSync, Boolean fParallel, TransparentNetworkResolutionState transparentNetworkResolutionState, Int32 totalTimeout)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.TdsParserStateObject.CreatePhysicalSNIHandle(String serverName, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Byte[]& instanceName, Byte[] spnBuffer, Boolean flushCache, Boolean async, Boolean fParallel, TransparentNetworkResolutionState transparentNetworkResolutionState, Int32 totalTimeout)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, Boolean isFirstTransparentAttempt, SqlAuthenticationMethod authType)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover, Boolean isFirstTransparentAttempt)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
    (01) 2017-01-05 10:10:46 Slp:                 at System.Data.SqlClient.SqlConnection.Open()
    (01) 2017-01-05 10:10:46 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlScriptExecution.GetConnection()
    (01) 2017-01-05 10:10:46 Slp:                 at Microsoft.SqlServer.Configuration.Sco.SqlScriptExecution.Connect()

    I have a new machine with Windows 10 (not upgraded).

    The error reported by setup: 

    Detailed results:
      Feature:                       Database Engine Services
      Status:                        Failed: see logs for details
      Reason for failure:            An error occurred during the setup process of the feature.
      Next Step:                     Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
      Component name:                SQL Server Database Engine Services Instance Features
      Component error code:          -2147467261
      Error description:             Object reference not set to an instance of an object.
      Error help link:               http://go.microsoft.com/fwlin



     

    Thursday, January 5, 2017 9:22 AM
  • Tried SQLServer2016-SSEI-Dev.exe as well, no luck. Help would be appreciated.
    Monday, February 6, 2017 5:27 PM