DBs are not opening in SSMS

SQLIsGood-7036 176 Reputation points
2022-08-04T15:50:36.2+00:00

SQL Server 2016

I am in SSMS and clicking on DBs, but they are not expanding. It used to work without a problem. Windows Server is up and running. All the L/M/T drives are in normal range. Would rebooting the windows server help?

Please see screenshot below. Please advise. Thanks.228208-2022-08-04-11h03-37.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,064 questions
SQL Server | Other
{count} votes

3 answers

Sort by: Most helpful
  1. Tom Phillips 17,771 Reputation points
    2022-08-04T16:32:58.46+00:00

    There are many reasons this would happen.

    SSMS queries the server for the list. This query can be blocked by several things. You need to look at what is running on the server and what is blocking the query from SSMS.

    0 comments No comments

  2. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2022-08-05T06:51:40.923+00:00

    Hi @SQLIsGood-7036 ,

    Did you restart your SSMS? Which version is your SSMS? Suggest you using the latest version SSMS 18.12.1, you can get it from here. Did you do some changes on your server before this issue occurred?


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments

  3. Łukasz Przyjemski 11 Reputation points
    2023-01-05T01:34:56.967+00:00

    There are a few possible reasons why your databases are not expanding in SSMS:

    1. The SQL Server service may not be running. You can check the status of the service by going to Services in the Windows Control Panel and looking for the service named "SQL Server (MSSQLSERVER)". If the service is not running, try starting it.
    2. There may be a connectivity issue between SSMS and the SQL Server instance. You can try connecting to the instance using a different tool such as SQLCMD to see if you are able to connect.
    3. There may be a problem with the SSMS application itself. You can try repairing or re-installing SSMS to see if that resolves the issue.
    4. Rebooting the Windows Server may help if there is a problem with the operating system itself, but it is not likely to fix the issue if one of the other problems is the cause.

    I recommend trying these steps in the order listed and seeing if any of them resolve the issue. If you are still having trouble, there may be other factors at play, and it would be helpful to have more information about your environment and the specific error messages you are seeing.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.