Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.

I'm trying to install BSM 2005 into a Win/2003 Server running SQL Server 2005 (everything) and the Web Service won't install because it reports the following:

Failed Microsoft OLE DB Provider for OLAP Service (MSOLAP) 2000 SP4 (8.00.2039)

as well, the Alerts won't install because of the message:

Failed Microsoft SQL Server 200 Notification Services 2.0 SP1 Engine Components

I understood that this version was compatible with SQL 2005. Any idea how to bypass these checks and install the software properly


Answer this question

Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.

  • Markus Fischer

    Hi Dave,

    There were some other questions around the BSM installation on the forums. Does the information on this post help resolve your issue

    http://forums.microsoft.com/msdn/ShowPost.aspx PostID=98463

    If not, please post your reply and we'll escalate the issue to our support team.

    thanks,
    -brenda (ISV Buddy Team)

  • programmer newb

    I got past this hurdle by uninstalling Analysis Services, going through the PTS installation, and reinstalling AS plus SP4.
  • temosol

    It looks like you can download this from the Microsoft Downloads site. Here's the KB article I found on the subject:
    http://support.microsoft.com/default.aspx scid=kb;en-us;312876

    I hope this is what you're looking for.
    -brenda (ISV Buddy Team)

  • NASSONS

    Please try installing the SQL Server 2000 SP4 and let me know if you're still having the same issue with the BSM installation.

    http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx


    -brenda (ISV Buddy Team)

  • I.Blagoev

    Hi, I've installed all the pre-requisites, including PSTLite.exe, and still cant proceed with the install (the msolap 8.0 webservice fails). Have you done everything else to successfully install

    Thanks.

  • johnmont

    Been able to resolve a couple of the issues:

    You must install the AS/2000 piviot table services (PTSLite) in order for the installer to proceed even if you're not planning on using this feature. Hopefully, the installer will be updated before general release.

    I've received a report from Microsoft that SQL Server 2005 NS isn't supported yet. At this point, I've skipped the installation of the Alert capability. Hopefully a fix or other work around if forth coming.

    Important: The Sharepoint publish seems to expect Intergrated Authentication to be turned on. (Basic doesn't work.) I'll be working to try to figure out what authentication schemes are currently supported.

  • DJS330

    When installing Business Scorecard Manager 2005 server, I had the following Failed messages:
    --Failed   Windows SharePoint services 2.0 or Microsoft SharePoint portal server 2003
    --Failed   Microsoft SharePoint extended site
    --Failed   Microsoft OLE DB Provider for OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)
    --Failed   Microsoft ADOMD.
    < xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />NET
    8.0
    --Failed   Microsoft SQL Server 2000 Notification Services 2.0 SP1 with Engine Components 
                      and SQL XML 2.0(SP3)

    I have installed the following files from Microsoft downloads to get the Business Scorecard Manager 2005 working:

    --SQL Server 2000 Notification Services, Enterprise Edition 2.0 SP1

    --Windows SharePoint Services with Service Pack 2
    --SqlXml 3.0 Service Pack 3
    --ptssetup.exe
    --SQL Server 2000 Desktop Engine (MSDE) Components

    I am still getting the following message when installing Business Scorecard manager 2005 server:
    --Failed
    Microsoft OLE DB Provider for OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)

    When I run ptssetup.exe, I get the message:
    --PivotTable Services 8.0 and MDAC are installed on this workstation.

    Do you know what I need to install or configure to make Microsoft Business Scorecard Manager 2005 Server install



  • zchuang

    I've escalated your question to our internal support team, but if anyone here has run across this issue please do jump in.

    -brenda (ISV Buddy Team)



  • Mariusz Gorzoch

    Hello Dave,

    Managed to get the file.

    Thanks.

  • thelonesoldier

    I do still have this problem, but I followed the installation requirements meticulously. I installed SP4 very early on.

    Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)
     May  3 2005 23:18:38
     Copyright (c) 1988-2003 Microsoft Corporation
     Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    I cannot run the script in PTSSETUP.htm, because of:

    Severe
    ---------------------------
    Setup cannot continue because the parent product, Analysis Services, is already installed.
    ---------------------------
    OK  
    ---------------------------

    and yet, the Scorecard Manger setup complains about:

    Failed Microsoft OLE DB Provider for OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)

    I am obviously installing on SQL 2000.


  • depl0y

    Dave or Fernando, could you look into this problem i am facing with the Business Scorecard Manager 2005 builder

    http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=125466&SiteID=1

    Thanks

  • Martin Moe

    Make sure you've installed the correct version of PSLite (the 8.0 release). It's version specific.

    Not sure what web service you're refering too, unless it's the BSM web service. In that case, definately check the PSLite version (and/or try installing the full version).

  • Sleek1

    Hi Fernando,

    could you send me an URL where to download the PTSLite file

    Thanks in advance,
    Dirk

  • walsh j

    Thanks for the update Dave. I'm glad that you were able to resolve or work around the install issues. I've passed on your comments to the product team.

    -brenda (ISV Buddy Team)

  • Installing Business Scorecard Manager 2005 on a SQL Server 2005 instance.