Unable to connect to Repository (timeout error: pre-login handshake)

Summary:

When attempting to connect to BI360 Reporting in Excel, the user receives the following error: 

Symptoms:

Unable to connect to Repository. Please check your connection settings.

OneStop.Framework.Repository.RepositoryException: Unable to connect to Repository. Please check your connection settings. --- System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) --- System.ComponentModel.Win32Exception: The wait operation timed out   --- End of inner exception stack trace ---   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)   at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean......

Cause:

This error may look familiar at first but the keyword is in the bold part. It states the application is able to establish a connection to the server but an error occurred during the pre-login handshake. The user has verified they can ping to the SQL server where the OSR_Repository is located from the local machine, and the anti-virus is not blocking the connection. 

Resolution:

Installing the latest version of .NET Framework available should resolve this issue. 

References:

Properties:

Applies To:

• BI360 Reporting 4.x