Post reply

Databases don't show in SSMS Object Exlorer

  • February 7, 2018 at 5:42 am

    #403095

    I have created a new login with read access to 2 databases.
    The user reported he could login to the instance suing SSMS but not see either of the databases in Object Explorer.
    He could only see system databases and database snapshots.
    I checked his permissions and they looked ok. 
    The login was integrated authentication. Just as a trial I created another user for him as a SQL Server Login but he had the same issue.
    If he launches a new query window he can Use Database and then run SQL queries against both the databases I granted access to.
    So it looks like the problem is confined to SSMS.

    I don't know if this is a bug or if there is some configuration setting I am missing. 

    Picture below of what can be seen in object explorer.

  • February 7, 2018 at 5:50 am

    #1978842

    bmcgee26 - Wednesday, February 7, 2018 5:42 AM

    I have created a new login with read access to 2 databases.
    The user reported he could login to the instance suing SSMS but not see either of the databases in Object Explorer.
    He could only see system databases and database snapshots.
    I checked his permissions and they looked ok. 
    The login was integrated authentication. Just as a trial I created another user for him as a SQL Server Login but he had the same issue.
    If he launches a new query window he can Use Database and then run SQL queries against both the databases I granted access to.
    So it looks like the problem is confined to SSMS.

    I don't know if this is a bug or if there is some configuration setting I am missing. 

    Picture below of what can be seen in object explorer.

    Were any changes made for public? By default it has view server state. If it's been changed, by default users will not see the databases. You can check with:
    SELECT
        l.name as Account,
        p.state_desc,
        p.permission_name
    FROM sys.server_permissions as p
    INNER JOIN sys.server_principals as l
    ON p.grantee_principal_id = l.principal_id
    WHERE permission_name = 'VIEW ANY DATABASE'

    Sue

  • February 7, 2018 at 7:01 am

    #1978861

    Thanks!, that was it exactly.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply