I have both SQL 2000 and SQL 2005 on my computer. I am running Windows XP
Pro, SP2. SQL 2000 was installed first, then, 3 months later, SQL 2005 was
installed, too.

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, which some people have suggested)?

I'm having the same issue, have you found a solution.

"Jerry B" wrote:

you guys are both in trouble; you need to format your machine; install
SQL 2000 Analysis and then install SQL 2005 on top.

out of the box; SQL 2005 will install as the 'default instance - aka
not named'

but that is the only place that SQL 2000 can land; so if you've
installed SQL 2005 out of the box (without specifying an instance path)
you can't install SQL 2000 Analysis on top.

Sorry; it drives me crazy also

-Tom


p wrote: