SSMS does not display the databases in the object explorer

  • We have started having some weird problems here. SQL Server Management Studio is not displaying the list of databases in the object explorer. However the databases are accessible from Query Analyzer running USE DB_Name command. This is happenning to all the accounts that are not administrators. Does anyone know what the deal is with SSMS to act like this? Thanks in Advance.

  • Does it give you any error when you connect to a server from Object Explorer ??

    Sanz
  • No it does not give me any error. Would there be any command that could be barring all these logins from viewing the databases in the object explorer?

  • Does it occur only at your end or did you try connecting to the server from any other machine ??

    Sanz
  • It happens where ever you connect from. When I connect from my machine as an admin I see all the databases listed. But when I use the other login that has db_owner access to two of the user databases, I cannot see any of the databases listed besides the system databases.

  • Has somebody by chance tweaked with the public role in an effort to secure the databases and server?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • USE master

    --revoke VIEW ANY DATABASE from public

    grant VIEW ANY DATABASE to [public]

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • This does not do the trick either. There seems to be something else that is not letting these logins to view the database.

  • It is finally fixed. Someone had messed up with the public role. View any database was granted but view any definition was denied. Since deny takes precedence over grant all the databases were not being displayed even though they had access to it.

Viewing 9 posts - 1 through 8 (of 8 total)

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