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.
View Complete Post