Skip to main content

*** Archive *** Missing tables In KSMS 6.7 when successfully connecting to a SQL Server 2017

Article # 3018435 - Page views: 243


Question / Problem: 

In KSMS 6.7 when connecting to a SQL Server 2017, we login fine, but we do not see any tables, or views, why?

Answer / Solution: 

Granting public, "View any database", and "View any definition" were the only permissions needed to view Databases in KSMS 6.6. You can grant permissions to "View any database" and "view any definition" under Login Properties | Securables | Explicit in SQL Server Management Studio. 

Applies to:  

Product Version
KTA 7.x