Intellisense not working over VPN

abhimanyu pawar 1 Reputation point
2022-05-19T06:12:25.34+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,551 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,656 Reputation points
    2022-05-19T07:02:06.263+00:00

    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.

    1 person found this answer helpful.
    0 comments
  2. YufeiShao-msft 7,056 Reputation points
    2022-05-19T09:00:16.647+00:00

    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.

    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 person found this answer helpful.