Slow first connection in SQL Server Management Studio

[dennisgorelik]

When I try to connect SQL Server Management Studio from my machine to our new SQL server (Windows Authentication) - it has initial ~30 seconds delay.

I had to spend few hours digging for the root cause.

It looks like the issue is that SQL Server Management Studio is trying to do reverse IP lookup when it tries to connect to SQL Server.
But SQL Server does not have fully qualified name connected to its IP address.
So that causes problems when running SSMS under Windows 10 (but there are no slowness when SSMS runs under Windows Server 2016).

The fix is to extend C:\Windows\System32\drivers\etc\hosts file:
https://dba.stackexchange.com/questions/104378/sql-server-management-studio-slow-connection-or-timeout-when-using-windows-authe/222588#222588

Comments

[juan_gandhi]

Well, not bad. Rather typical.

[dennisgorelik]

What do you mean is typical?
Trying to do reverse IP lookup?
Failure doing reverse IP lookup?

[juan_gandhi]

I vaguely remember some simple shit in Java, which was taking forever unless you have something in hosts - because it was suddenly deciding to go resolve a domain name over the internets for some pretty innocent local operation. I forgot the details.

[anspa]

Запомню на будущее. Спасибо.