I have created an Active Directory Group and created it as a user, we'll call it "AD SQL", in my DB. I can successfully login in using Active Directory Authentication and read/write.
However, Intellisense is not working for any Active Directory users.
If I log in using my Active Directory Admin, "AD ADMIN", Intellisense works fine.
Can anyone tell me what permissions/roles/view/etc are needed for a user to have access to Intellisense?
My "AD SQL" user the following roles/permissions:
- db_owner
- db_datareader
- db_datawriter
- GRANT CONNECT (DATABASE)
- GRANT VIEW DEFINITION (DATABASE)
And I have already tried Refreshing Cache/Restarting SSMS.
