No Analysis service in sql...

Posted on 2006-04-08
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

    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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    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.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now