We want to install sql server 2005 on Windows 2000 Server. We are able to install database service engine, analysis services engine and integration services.
But we are unable to install workstation components like SSMS.
Does anybody faced this problem? What is the fix for this?
Ok, given the clarification above, it seems pretty likely that you're hitting the same issue as this blogger.
Basically, the crux of what he was saying is that previously installed components confused the 2005 installer, so he renamed the 'Tools' directory to 'ToolsBak' and then used Add/Remove programs to change the installation, which repaired it.
Hope that helps.
answered Oct 29 '09 at 10:45 AM
Matt Whitfield ♦♦