Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sql client tools question

Author  Topic 

SQLLearner2
Starting Member

14 Posts

Posted - 2006-06-24 : 09:29:46
I have sql 2000 loaded on clustered servers. I tried loading a standalone instance of sql 2005 on one of them , which worked, but it messed up the client tools (EM, QA, etc) for sql 2000 on that server (the database itself is still intact). What's the simplest way to correct this?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-06-24 : 10:13:53
messed up how?


Go with the flow & have fun! Else fight the flow
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-06-24 : 10:36:08
I seem to remember seeing something about the DLLs getting mucked up, and a registry fix, or recopy the original DLLs or reinstall Client Tools from SQL2000 CD ... but I can't find the thread now - might be worth a bit of a Google for something along those lines

Kristen
Go to Top of Page

SQLLearner2
Starting Member

14 Posts

Posted - 2006-06-24 : 12:51:24
that's probably what it is. when i select EM from the start menu, an error window pops with MMC on it, containing the text

'Snap-in failed to initialize. Name: not available - CLSID {long string of numbers/letters in brackets}'.


When i click OK on this window, EM comes up, but it's pretty much an empty shell(doesn't have the sql servers, won't let you register new ones, doesn't have the regular options...file, tools, etc).
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-06-24 : 12:56:54
reinstall the client tools... easiest if you ask me.



Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -