haamethod.blogg.se - february 2023

Blackholed to 127.0.0.1 in my etc\hosts file.

Installed SSMS 2012 and tried that instead of 2014.

I also tried Named Pipes but my server isn't setup for that.

Force Network protocol to TCP rather than.

Renamed the "12.0" folder under "%userprofile%\AppData\Roaming\Microsoft\SQL Server Management Studio" to "_12.0" to force SSMS to recreate my user settings.

Also, the problem only appears when connecting to this specific SQL Server and VPN I can connect to other SQL Servers on the local network via Windows Authentication without any delay. These tests show that the problem is unique to my PC. When the same co-worker logged into my PC with his own domain account, he experienced the delay. When I logged into a co-worker's Windows 7 computer with my domain account, and connected to the same SQL Server through the same VPN, there was no delay.

The server is at a remote location connected via VPN.TCP connection via IP address (not hostname).The problem does not happen when I connect using SQL Server authentication. This happens when connecting Object Explorer or a new blank query window.

I'm getting extremely long delays (10~30 seconds) in SQL Server Management Studio 2014 when attempting to connect to a SQL Server 2012 instance over TCP using Windows Authentication.