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.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-11-14 : 14:57:05
|
| Hi,Can I uninstall and then reinstall sql server 2k client tools on server machine without causing any harm to server related registeries/dlls etc? My folks fear we could lose some important system files if we attempt to uninstall and reinstall toolset. If we do lose stuff, do I have to uninstall and reinstall entire server itself, I guess so? The reason i want to reinstall client-tools is because DTS doesn't work inspite of trying to re-register comcat.dll.Thanks,Sarat |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-14 : 15:04:04
|
| You can not just uninstall the client tools. I believe that the only option is to uninstall SQL Server. I checked one of our SQL Servers here, and the only option is to uninstall "Microsoft SQL Server 2000". I have uninstalled SQL Server numerous times and I don't remember seeing a separate option in the uninstall of it to just uninstall the tools. After you uninstall, you will have to reload everything.Edited by - tduggan on 11/14/2002 15:05:06 |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2002-11-14 : 15:18:34
|
| How about bringing server offline, then reinstalling (not uninstall as you mentioned but something like overwriting?) the MDACs and the Client Tools on the Server?. Then reapply the Service Pack 2? Any chance now? Isn't there an easy way out? I hate to touch the server just for the sake of DTS!Sarat. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-14 : 15:42:49
|
| I'm pretty sure that won't work. But it's worth a shot, just be sure to have full backups of the databases before you do anything. I have had to uninstall and reinstall SQL Server just for the sake of DTS, and it was annoying, but it was worth it. It's better to have everything working properly. |
|
|
|
|
|
|
Installing Client tools