No Analysis service in sql...

Posted on 2006-04-08
Medium Priority
Last Modified: 2010-03-01
I have an suscription to the microsoft action pack.  This includes a new CRM software which I would like to demo.  I have upgraded my sbs2003 server to premium, and have added sql off of sbs disc 5.  During the crm install it calls for several updates, including sql sp4.  I receive and error message that stats I have no analysis service on the machine.  I have checked  my install my programs directory and it contains:

Reporting Services (folder)
Books Online
Client Network Utility
Configure SQL XML Support in IIS
Enterprise Manager
Import and Export Data
Query Analyzer
Server Network Utility
Service Manager

I have tried to add the component off of the sql install and cannot locate it.  The error I get when trying to update sql is

You must install analysis service 2000 before you can install a service pack.

Does anyone know how I can get this?  Perhaps a direct download???
Question by:supertechonsite
1 Comment
LVL 28

Accepted Solution

imran_fast earned 1500 total points
ID: 16411415
Check it on the CD of Sql server 2000 you should have it as SQL Analysis server 2000 install it from the CD. It has a  seperate setup file.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question