MMC could nt create the snap in

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)

MMC could nt create the snap in

Author

Topic

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-20 : 15:58:37

Gurus
on my windows server i have both sql server 2000 and sql server 2005.Recently i uninstalled sql server 2005 and when i logged in on enterprise manager i got his error in sql server 2000.
WHat is this error?Beacuase of this error we cannt connect to enterprise manager

Regards
Nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-06-20 : 15:59:49

Reinstall the 2000 client tools.

Tara Kizer
aka tduggan

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-20 : 16:37:29

Yes tara
i am doing it,but it is sayi that i have to put the installation in maintenace mode
How do i do that?
Regards

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-06-20 : 16:38:36

I don't know what that means and have never seen it. Could you post the exact message?

Tara Kizer
aka tduggan

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-20 : 17:05:57

i will tell you the steps
1)run set up
2)sql server 2000 componets
3)install db server
4)upgrade,remove or add componets to an existinf instance of sql server
5)add components to your existing installation
6)then we uncheck every componets except client connectivity and it gives the error you have not selected any componest to install .
when i check cliewnt connecttivity i dnt see any component in sub component window

Regards
Nitin

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-20 : 17:09:51

and when in step 4 we create a new instance and install only client tools we get this error

"setup has detected an existing client tool only istallation>please use the maintence mode to add client components"

Regards
Nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-06-20 : 17:10:30

You need to select Create a new instance of SQL Server, or install Client Tools instead of the upgrade, remove, or add components option.

Tara Kizer
aka tduggan

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-06-20 : 17:11:59

Then try uninstalling the tools, then reinstall them.

Tara Kizer
aka tduggan

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-20 : 17:12:24

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-20 : 17:17:42

now ho do i uninstall these client tools?
Regards
Nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-06-20 : 17:18:11

Add Remove programs in Control Panel just like any other uninstallation.

Tara Kizer
aka tduggan

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-20 : 17:30:32

tara
there is no explicit option fro client tools for sql 2000 although i can see sql native client for 2005

Regards
Nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-06-20 : 17:33:26

Did you try googling on the error that you are getting in Enterprise Manager? There is probably an easy fix for it. You didn't post it here, so I can't google it for you (like we usually do for you).

Tara Kizer
aka tduggan

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-20 : 17:37:31

tara
i can just see client utility when i log in to my server under sql server 2000.
NO enterprise manager
no query analyzer
nothing??
what is this going on?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-06-20 : 17:39:50

You originally said that you were getting a snap in error from Enterprise Manager. We need to know what the exact error message is in order to help.

Tara Kizer
aka tduggan

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-20 : 17:41:45

now i can not see enterprise manager or anything
i can only see client network utility.Thatz it

have we uninstalled someting?
Plz help
regards
Nitin

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-06-20 : 17:43:18

I have no idea what you've done. I'm not there to see your system. Can you run isqlw.exe from Start..Run?

Tara Kizer
aka tduggan

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-06-20 : 17:45:57

yes i can see query analyzer
Now?