Sitecore: Installer Issue: SQL Server connection validation failed: Arithmetic operation resulted in an overflow

Recently we found a strange issue while performing a brand new install of Sitecore 8.0 and Sitecore 8.1 Update 3

Issue

As we pass the installer prompts, upon entering the SQL username and password we received the following error: “An error occurred while attempting to connect to SQL Server: Arithmetic operation resulted in an overflow. See the log file for details.

One could connect to the SQL Database via SQL Management Studio.
There is a thread in the sitecore community discussing the same: https://community.sitecore.net/developers/f/5/p/4257/12706#12706

The suggestions listed were valid, to check SQL service, SQL browser service, App Pool settings and finally re-install SQL Server. Those are valid suggestions, however the problem persisted.

We did not want to re-install SQL Server, as we knew the underlying SQL Server was perfect.
We had to identify the root cause of the issue. In order to determine the root cause we had to find the exception via the Sitecore installer.

Analysis

To find the Sitecore Log go to the C:\Users\<username>\AppData\Local\Temp folder.
Sitecore creates installer log file in this location. You will find a “SitecoreInstaller.log” file.

View the content of this file.

Below is the exception we were noticing:

ACTION: ‘SitecoreInstallWizardCore.Actions.OSCompatibilityAction’ completed successfully.

ACTION: ‘SitecoreInstallWizardCore.Actions.VerifyIISAction’ completed successfully.

ACTION: ‘SitecoreInstallWizardCore.Actions.AspNetRegisteredInIISAction’ completed successfully.

ACTION: ‘SitecoreInstallWizardCore.Actions.VerifyWebClientAction’ completed successfully.

ACTION: ‘SitecoreInstallWizardCore.Actions.InstallationModeAction’ completed successfully.

ACTION: ‘SitecoreInstallWizardCore.Actions.RemoveDatabaseParametersAction’ completed successfully.

Exception:

System.Data

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.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)

at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)

at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)

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 SitecoreInstallWizardCore.Utils.SQLUtil.TestSqlServerConnection(String connectionString, String userName, Boolean verifyUserSysadmin, Boolean verifyInstanceLocal)

Exception:

System.Data at SNIOpenSyncExWrapper(SNI_CLIENT_CONSUMER_INFO* , SNI_ConnWrapper** )

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)

at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)

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 SitecoreInstallWizardCore.Utils.SQLUtil.TestSqlServerConnection(String connectionString, String userName, Boolean verifyUserSysadmin, Boolean verifyInstanceLocal)

ACTION: ‘SitecoreInstallWizardCore.Actions.DatabaseTestConnectionAction’ failed.

It was clear that the Sitecore Installer, SitecoreInstallWizardCore.Actions.DatabaseTestConnectionAction check was failing.

There was nothing wrong with SQL Server. Hence, a re-install of SQL Server is not required.

Root Cause

Strangely enough, we found a WebCompanion Service Lavasoft that was causing a conflict.

Resolution

Open the services window: services.msc.
Stop the LavasoftTcpService (from services.msc)
Uninstall WebCompanion from Program and Features.
Rename the two dlls (LavasoftTcpService.dll and LavasoftTcpService64.dll in C:\Windows\System32 and C:\Windows\SysWOW64) if still present