Results 1 to 5 of 5

Thread: Analysis Services - Provider cannot be found

  1. #1
    Join Date
    Jun 2003
    Posts
    5

    Question Analysis Services - Provider cannot be found

    I've got a big problem with the Analysis Services.
    I have a SQL Server 2000 SP3 and the Analysis Services SP3 running. The SQL Server has no problems.
    When I try to browse the Data of any cube, the following error message occurs:
    "Provider cannot be found. It may not be properly installed." When I try to browse other cubes after this, the error message "unknown error" occurs.
    The databases, on which the cubes are based are both Access2k and SQL Server 2k. The error even appears at the test cubes from Microsoft, so it cannot be simply a problem of the database.

    Much thx for your answers.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you browse from server or client pc? With analysis service mmc or other app? Did you add your windows account to olapadmin local group on the server?

  3. #3
    Join Date
    Jun 2003
    Posts
    5

    Provider not found

    I did browse on the SQL Server itself.

    I mean the Analysis-Manager.
    Did you mean this by analysis mmc? Or what is the other tool?

    Yes I did add the Account, which is specifically for the SQL Server and its components to the Local OLAP Administrators group. I made a reboot of the server to aktualize, but it didn't fix the problem.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    You can try reinstall mdac. By the way, other tools are excel or third party's tool.

  5. #5
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •