Hi,
I have a simple question about OLAP installation. Can I install Microsoft
OLAP service independent of MS SQL Server?
That is, I only want OLAP service on my computer to process MS Access data.
I don't want SQL Server at all.

Thank you.

That is absolutely possible. Many customers run that way.
In SQL Server 2000 they are totally separate installs.
However, even if you have not installed the RDBMS, you still must have a SQL
Server license to install and run Analysis Services standalone. There is no
separate license for Analysis Services -- it is licensed as a component of
SQL Server, so you must have a SQL Server license for the machine.

With the upcoming SQL Server 2005, the tuntime services are still separate,
but many of the utilties are shared, e.g. Profiler is used to trace both
RDBMS events and AS events, SQL Mgmt Studio is used to administer both the
RDBMS and AS.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Thomas Lee" <lee_nospam (AT) dejibook (DOT) com> wrote