Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

OLAP services 2000 together with SQL server 2000?

0 views
Skip to first unread message

Falco Paul

unread,
Jan 17, 2001, 4:33:56 AM1/17/01
to
Hello everybody!

Can someone help me with this one?

I have a SQL SERVER 7 system running just fine.
Both the database server and OLAP services are installed together on a
single machine.

Can I upgrade JUST the OLAP services component to SQL SERVER 2000?

So, I want to run the SQL SERVER 7 database and the SQL SERVER 2000 OLAP
services
together on the same machine.

I think this is possible, sine the two components are completely seperated
in SQL SERVER 7.
But is this really possible? Would it be save to upgrade like this?
Has anyone got some experience with this?

Regards,
Falco


thomas ivarsson

unread,
Jan 17, 2001, 6:35:04 AM1/17/01
to
I doubt that you save any license fees because analysis server i bundled
with SQL server 2000.
You can have both SQL server 7 and SQL Server 2000 on the same machine but
I'm not sure
if this is officially supported by Microsoft. If you run MOLAP cubes
everything except pumping new
data from the database will occur in the OLAP engine, except ROLAP
dimensions.

Regards
Thomas Ivarsson
DW Consultant Sweden


"Falco Paul" <fa...@palm.nl> wrote in message
news:943os6$nb0$1...@azure.nl.gxn.net...

Falco Paul

unread,
Jan 17, 2001, 6:47:37 AM1/17/01
to
Hi, thanks for the reply.

It's not a license issue.
We have a SQL server 7 database running that we don't want to upgrade
('political issue')
However, we are very much interested in upgrading the OLAP services.
We really like to use some of the new features in analysis services.

Regards,
Falco

"thomas ivarsson" <thomas.iva...@telia.com> schreef in bericht
news:ONmjAmHgAHA.1724@tkmsftngp05...

Norbert Kessler

unread,
Jan 24, 2001, 7:24:56 AM1/24/01
to
We did this at several of our Customers which didn't want to upgrade SQL at
this time.
It works fine until now. The only thing was that a few clients couldn't
connect any longer
with OLE DB for OLAP Provider from SQL 7.0 to the AS 2000. So we had to
install the new Client Components there (Some Win 98 Clients).

Regards
Norbert Keßler

"Falco Paul" <fa...@palm.nl> schrieb im Newsbeitrag
news:943os6$nb0$1...@azure.nl.gxn.net...

0 new messages