SSMS 17.5 Intellisense not working for Azure Server
I am running SSMS 17.5 and attaching to an Azure server with 35 Databases and over 50 users.
If I connect to a local DB intellisense works fine. On the Azure server there is nothing. No Intellisense at all. It is turned on (TextEditor -> IntelliSense -> Enable Intellisense) and working against other servers.
My questions are:
Could this be a bug in SSMS 17.5?
Is there a setting in SQL server to disable Intellisense queries?
This has been addressed.
Please, give it a try on the latest version of SSMS (17.9 currently).
Kim Hjort Madsen commented
This still doesn't work, I've tried 17.9.1.
I am using 17.9.1, but still having same issue. IntelliSense work for local sql server, but does not work on Azure SQL Server
Nick Allan commented
Not working for me either. SSMS v17.9.1
Dan W commented
This still doesn't work, I've tried 17.9 and 18 preview 4.
This is still not working and is a major issue for us. I am aware of the technical reasons for it regarding non-sysadmin but this doesn't help address the problems it causes. Please get this rectified as it's limiting our ability to utilize Azure SQL.
John Colbert commented
Still not working in 17.9.
Ronen Ariely (pituach) commented
Paul, thanks for sharing the connect.
1. This is true to any version at this time including 17.6
2. This is NOT related to any connection to the Azure Database, but only when you connect with a LOGIN that is not a sysadmin (A LOGIN that you created)
* in the link that the "Anonymous" add I gave more explanation
** The developers team already know about this issue (I reported this directly)