![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
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
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