Sample Header Ad - 728x90

SQL Server Permissions for Intellisense for an Active Directory User?

1 vote
0 answers
84 views
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.
Asked by Dave (11 rep)
Jul 9, 2019, 10:18 PM