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

Improve this question
1
  • I am accessing the sql server instance remotly
    – kinnangiant
    Nov 24, 2022 at 9:00

1 Answer 1

Reset to default
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.

Improve this answer
9
  • Done all of the above no use
    – kinnangiant
    Nov 23, 2022 at 15:17
  • @kinnangiant Restarting the SSMS client completely doesn't work (even just temporarily)?
    – J.D.
    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.stack.imgur.com/o8xFl.png
    – kinnangiant
    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.
    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
    – kinnangiant
    Nov 30, 2022 at 14:20

Your Answer

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

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