I'm trying to connect a remote server by
IP,port via Windows authentication.
It will end out with the following error
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=41306; handshake=27677; (Microsoft SQL Server, Error: -2)
However, if connect to
IP,port but login with
sa through SQL Server authentication then I can connect to the server correctly.
Moreover, if I switch to
MachineName,port and login via Windows authentication then I can successfully connect too.
Not sure what kind of setting/adjustment I need to make this use case work.
- My laptop is Win10 and the SQL Server 2012 is on a Windows server 2012 R2
- These two machines are in the same domain.
- We are using another port instead of default 1433.
Case I tried
IP,portvia Windows authentication - failed
MachineName,portvia Windows authentication - successful
IP,portvia SQL Server authentication(sa account) - successful
IP\MSSQLSERVER,portvia Windows authentication - failed
- RDP to remote then use ssms there
IP,portvia Windows authentication - successful
Setting I have tried
- Add the SQL Server exe to the inbound rule
- Launch SQL Server browser
- Change IP1 to the IPv4 I'm using and Active/Enabled it(restart service too)
- Make sure TCP/IP are enabled on Protocols of MSSQLSERVER and Client Protocols(/32bit)
- Add the port I'm using to IPAll/TCP Port and keep Dynamic ports blank