0

My sql server management studio intellisense is not working, below is my SSMS version and screen shot that I have tried, my SQL server is not installed locally but I am accessing the sql server remotely, maybe a firewall issue?

enter image description here

enter image description here

enter image description here

enter image description here

It works at will, sometimes work sometimes does not work

enter image description here

enter image description here

I have this blue icon on my database instance, it might be blocking it as it is some firewall issue

enter image description here

1
  • I am accessing the sql server instance remotly Commented Nov 24, 2022 at 9:00

1 Answer 1

3

Intellisense has always been a little buggy.

Sometimes refreshing your intellisense cache fixes it, which you can accomplish with the shortcut of Ctrl + Shift + R. Sometimes you need to close the SQL worksheet and open a new one. Other times you unfortunately need to just restart SSMS completely.

9
  • Done all of the above no use Commented Nov 23, 2022 at 15:17
  • @kinnangiant Restarting the SSMS client completely doesn't work (even just temporarily)?
    – J.D.
    Commented Nov 23, 2022 at 19:23
  • no not even temporarily, it might be firewall issue as i am seeing a blue icon on my database instance, it means that due to some firewall policy it shows a blue icon on the database i.sstatic.net/o8xFl.png Commented Nov 24, 2022 at 8:48
  • @kinnangiant I've never heard of the firewall affecting intellisense, but I guess anything is possible. If you directly login to the server hosting your SQL Server instance (e.g. via RDP) and run SSMS locally on it, does intellisense work? This would remove the factor of the firewall. And for that matter, does anyone else using your SQL Server experience this issue?...does everyone else experience it?
    – J.D.
    Commented Nov 24, 2022 at 13:45
  • 1
    I am in discussion with redgate on this, and it has not been closed yet, lets see what they have to say, as I am working with them and showing them but still it does not work on my system Commented Nov 30, 2022 at 14:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.