Sample Header Ad - 728x90

Intellisense not working over VPN

1 vote
0 answers
491 views
I'm running SSMS 2019 on my laptop, connecting to 2 different SQL Servers - 2008 R2 and a SQL 2016 machine. When I'm physically in the building where the servers reside, Intellisense works great. But on days when I'm working from home, connected through VPN, Intellisense is very spotty. Usually it completely fails to work at all, but every once in a while, it'll auto-fill a database name as I type, but never a table or field name. I've tried refreshing the local cache (CTRL+Shif+R), but that hasn't helped. Any ideas? As requested below, here are the results of running Test-NetConnection "Emden" -port 1433 over VPN connecion:
PS C:\Users\cjm> Test-NetConnection "Emden" -port 1433


ComputerName     : Emden

RemoteAddress    : 192.168.10.56

RemotePort       : 1433

InterfaceAlias   : Ethernet 2

SourceAddress    : 192.168.11.46

TcpTestSucceeded : True
Asked by Chris Miller (11 rep)
Oct 16, 2020, 10:18 PM
Last activity: Nov 24, 2020, 02:17 PM