FIX: TCP Timeout or login time-out error occurs when you connect to SQL Server 2017 using Integrated Authentication

Taikoma: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core

Symptoms


Ifyou connect to SQL Server 2017 by using IntegratedAuthentication, then TCP Timeout or login time-out error may occur. After you apply Cumulative Update 13, Active Directory lookup for SID will switch to pre-emptive mode and avoid non-yield errors during login process.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

Resolution


The issue is fixed in the following cumulative update for SQL Server:

About cumulative updates for SQL Server:

Each new cumulative update for SQL Server contains all thehotfixes and all the security fixes that were included with the previouscumulative update. Check out the latest cumulative updates for SQL Server:


References


Learn about the terminology that Microsoft uses to describe software updates.