[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

Error in expand database in SQL Server management Studio

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.
0
chuang4630
Asked:
chuang4630
  • 2
2 Solutions
 
rmm2001Commented:
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?
0
 
chuang4630Author Commented:
SQL Agent is not running.
0
 
jogosCommented:
Error log is actualy a file so you can find it on your disk http://msdn.microsoft.com/en-us/library/ms187885.aspx
0
 
chuang4630Author Commented:
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.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now