This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Is there any issue with IntelliSense of SSMS when we connect to database server over VPN from local SSMS client? Tried all available troubleshooting options listed in SQL Server documentation but still it is not working. Could be a latency issue causing it?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 84%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYM%3C/text%3E%3C/svg%3E)
Could you please validate all the answers so far and provide any update?
Please remember to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.
Thank you for understanding!
Is there any issue with IntelliSense of SSMS when we connect to database server over VPN from local SSMS client?
No, not directly related to VPN, VPN is just a type of connection.
SSMS fetches the meta data like existing tables via common SQL queries.
But IntelliSense in SSMS never worked very well, at all.
Hi @abhimanyu pawar ,
What is the version of your SSMS and SQL Server? When you have tried all available ways:https://learn.microsoft.com/en-us/sql/ssms/scripting/troubleshooting-intellisense?view=sql-server-ver15
You'd better use the latest version of them
Wheather you have enable IntelliSense? Please check Tools>Options>Text Editor > Transact-SQL > IntelliSense
For each opening query window, please go to Query >> Intellisense Enabled.
Enable statement completion: please go to Tools >> Options >> Text Editor >> Transact-SQL >> General, and check on Auto list members and Parameter information boxes.
Is SQL Server installed on the same machine as your SSMS? When you connect to remote server, Intellisense may not work well
It could also be because over VPN is adding enough latency that it is disrupting IntelliSense
https://dba.stackexchange.com/questions/278227/intellisense-not-working-over-vpn
-------------
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.
Regards