SQL Server databases missing from SSMS Object Explorer Print

  • Plesk
  • 53

A Plesk security update restricted database listing on our shared SQL Server hosting to prevent customers from seeing other customers’ database names. This also prevents your own databases from appearing in SQL Server Management Studio (SSMS) Object Explorer. Your databases remain accessible, and your websites and applications are unaffected.

To manage your database in SSMS, open the connection window and select Options → Connection Properties. Manually enter your database name in Connect to database, then connect using your database login credentials.

Once connected, select New Query to manage your tables, data, views, and stored procedures using SQL commands. You can confirm the selected database by running:

SELECT DB_NAME() AS current_database;

Connecting directly does not restore the Object Explorer database tree. Restoring that listing requires a permission that exposes every database name on the server, so it is restricted on shared hosting and reseller accounts.


Was this answer helpful?

« Back