Error in expand database in SQL Server management Studio

Posted on 2011-10-08
Last Modified: 2012-05-12
I have a SQL 2008 R2 installed in my home. I have not accessed it for several months. When I try to access it this morning, the SQL Server management Studio does not allow me to expand the "Database" and 'Managment". However, I can see the database int he dropdown list of the databases, I can create the new query with intelliSense.

Anyone can help me on this? I tried to see the SQL Sever Error Log, but hte Management is not expandable.
Question by:chuang4630
    LVL 7

    Accepted Solution

    Are you logging in with the same user? And does that user have permissions to the explorer? Have you tried restarting the service? Restarting SSMS?
    LVL 1

    Author Comment

    SQL Agent is not running.
    LVL 25

    Assisted Solution

    Error log is actualy a file so you can find it on your disk
    LVL 1

    Author Comment

    The root cause if taht the SQL Agent was not running. Once I manually started this service, the error went away. Of course, I later restarted the machine to ensure the full recovery. Thank ou all for responding to my questions.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now