Can''t expand Databases node

• Jon Moore

  SSC Enthusiast

  Points: 115

  More actions

  September 12, 2007 at 3:03 am

  #180956

  Hi everyone,

  I am experiencing a really weird problem. I am running EPM on my local machine attempting to access a remote server. When I try to expand the databases node for that server, I just get an hourglass and it hangs for ever. I can expand all the other nodes with no problem.

  I have already been authenticated by this point.

  The remote server is running SQL 2000 SP4 v.8.00.2039

  Can anyone help please!!!???

  Cheers,

  Jon

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  September 12, 2007 at 6:39 pm

  #733331

  Can you run DBCC CHECKDB against master and see if there are any corruptions?

  What happens if you manually run 'select * from master..sysdatabases'?

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  September 14, 2007 at 10:37 am

  #733835

  I would connect to the server using QA and then execute a few things:

  • sp_helpdb
  • dbcc checkdb(master)
  • dbcc checkdb(user_database)

   

  If these tings function correctly I would probably reinstall EM on the client machine.

  However of you have trouble connecting with QA then you may have a network issue.

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."