dennisgorelik: 2020-06-13 in my home office (Default)
[personal profile] 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
This account has disabled anonymous posting.
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting

Profile

dennisgorelik: 2020-06-13 in my home office (Default)
Dennis Gorelik

June 2025

S M T W T F S
1234 567
891011 12 13 14
15161718192021
22232425262728
2930     

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 7th, 2025 05:35 am
Powered by Dreamwidth Studios