My client needs me to work with SQL 2000 Analysis Services (my client is on a SQL 2K platform). I have the full SQL 2005 Developer Edition on my machine, along with the SQL 2005 Analysis Services, SSIS, Visual Studio, SSMS, etc. I also have SQL 2000 Developer Edition, but I don't see SQL 2000 Analysis Services on the machine nor running under services. In addition, there is no Analysis Services on my machine.
Therefore, I wanted to install SQL 2000 Analysis services onto my machine. However, when I do, I get the message:
"To install a new version of Analysis Services, you must first remove your existing version."
However, I cannot uninstall Analysis Services. It does not show up under Add/Remove New Programs in Control Panel. There is no MSSQLServerOLAPService service running. I do have a two Analysis Service services running with other names: BUCKNOFF2005 (which is, obviously, my 2005 Analysis Services) and MSSQLSERVER, which also displays in my SQL 2000 SQL Server Service Manager, so there might be some artifacts from an old install of SQL 2000 Analysis on my machine.
SQL 2005 Analysis Services runs fine, by the way.
So I am stuck. I can neither install nor uninstall. Bottom line, how can I uninstall SQL 2000 Analysis Services (without reformatting my hard drive or starting over again on another computer) If I can do that, then I can reinstall it. Right now, as a temporary solution, I borrowed a laptop from my client and installed Analysis Services 2000 for the 2 days that I will be working with it -- but I need to get this fixed on my own laptop which I take from client to client.