question

abhimanyupawar-1796 avatar image
0 Votes"
abhimanyupawar-1796 asked Yufeishao-msft commented

Intellisense not working over VPN

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?

sql-server-generalsql-server-transact-sql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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!

0 Votes 0 ·
OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered

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.
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yufeishao-msft avatar image
1 Vote"
Yufeishao-msft answered Yufeishao-msft commented

Hi @abhimanyupawar-1796,

What is the version of your SSMS and SQL Server? When you have tried all available ways:https://docs.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.

https://social.msdn.microsoft.com/Forums/en-US/cc07c837-5729-4c38-9f4f-3e9cba02af82/intellisense-autocomplete-wont-work-on-ssms?forum=sqltools

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.





· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If the reply above was helpful please mark as accepted answer so it can be helpful for other community members with same questions.

Regards

0 Votes 0 ·