| 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
|
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 |
|
|
|
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? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-20 : 17:49:18
|
Then you didn't uninstall it. So we need to see the error.
Tara Kizer
aka tduggan |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-06-20 : 17:51:44
|
this error came yesterday
and yesterday i was able to coonect it thru query analyzer
but todauy i am nt able to.
where do i check the error?
Nitin |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-20 : 17:53:34
|
How am I supposed to tell you how to check the error if I don't even know what it is? I give up.
Tara Kizer
aka tduggan |
|
|
|
Previous Page&nsp;
Next Page
|
MMC could nt create the snap in