1

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

Hannah Vernon
  • 70,928
  • 22
  • 177
  • 323

0 Answers0