Microsoft Office Business Scorecard Manager 2005 runs with either SQL 2000 or 2005. The benefits of upgrading to SQL Server 2005 are countless: http://www.microsoft.com/sql/bigdata/default.mspx?CMP=KNC-SQLQ2-PS
http://www.microsoft.com/technet/prodtechnol/sql/themes/default.mspx

The majority of enhancements in SQL Server 2005 are accessible to Business Scorecard Manager through a consistent set of interface standards common to both SQL Server 2000 and 2005. For example, Business Scorecard Manager can generate its scorecards in Microsoft's Report Definition Language (RDL) used by SQL Server Reporting Services. A new feature in SQL Server 2005 is the ability to embed RDL reports in custom applications, both through winforms and webforms. Put the two together an now you can consume scorecards in your custom apps thanks to the new platform.

There are additional enhancements to the BI platform that introduce new APIs and additional light-up features are being made available in a modular fashion through projects like KPIUtil.exe (http://www.microsoft.com/downloads/details.aspx?FamilyId=556E01A4-49A2-4A61-BEC5-0260B42DCF1B&displaylang=en) which takes advantage of KPI definitions that were created in the Analysis Services cube while it was being designed.

Out-of-the-box, the Business Scorecard Manager documentation walks you through installation using a SQL Server 2000 example and steps for SQL Server 2005 are available in the readme (note that the standards-based approach enabled Business Scorecard Manager to be released prior to SQL Server 2005 while being tested on the CTP version noted in the documentation): http://download.microsoft.com/download/f/d/4/fd4261fc-b0a7-4f14-a2b8-f8ef732eca9c/ReadMe.htm

The best source of information on the product install is the official documentation:

Readme (includes links to downloads): http://www.microsoft.com/downloads/info.aspx?na=46&p=3&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=D2F8C636-602D-4744-BA7D-D3821F8920D5&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2ff%2fd%2f4%2ffd4261fc-b0a7-4f14-a2b8-f8ef732eca9c%2fReadMe.htm&oRef=http%3a%2f%2foffice.microsoft.com%2fen-us%2fFX012225041033.aspx

Administration Guide: http://www.microsoft.com/downloads/info.aspx?na=46&p=1&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=D2F8C636-602D-4744-BA7D-D3821F8920D5&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2ff%2fd%2f4%2ffd4261fc-b0a7-4f14-a2b8-f8ef732eca9c%2fAdminGuide.exe&oRef=http%3a%2f%2foffice.microsoft.com%2fen-us%2fFX012225041033.aspx

Here's a modified excerpt from the ReadMe with some additional links:

Business Scorecard Manager Server Prerequisites

You must install the following prerequisite software in this order before installing the Business Scorecard Manager Server Web services:

1.      Microsoft Windows Server™ 2003 with Service Pack (SP) 1

http://www.microsoft.com/technet/downloads/winsrvr/servicepacks/sp1/default.mspx

2.      Microsoft .NET Framework 1.1 with ASP.NET 1.1 enabled

3.      Microsoft Internet Information Services (IIS) 6

4.      Microsoft SQL Server^TM 2005 

Note: To install Business Scorecard Manager Server on a computer on which SQL Server 2005 Analysis Services is already installed, you must run SQL Server 2000 Analysis Services PivotTable® Service Lite SP 4 (Ptslite.exe). This should be available on the SQL Server 2005 CD; it's also installed when you install SQL Server 2000 Analysis Services SP 4. For more information, see Analysis Services Programming Redistributing Components: http://go.microsoft.com/fwlink/?linkid=52910

5.      SQLXML 3.0 SP 3 (This is required if you use SQL Server Alerts.) Download SQLXML 3.0 SP 3: http://go.microsoft.com/fwlink/?linkid=52919

6.      MSXML 4.0 with SP 2. Download this from the Microsoft Download Center: http://go.microsoft.com/fwlink/?linkid=52926

7.      ADOMD.NET 8.0. Download this from the Microsoft Download Center: http://go.microsoft.com/fwlink/?linkid=52928

Note: If you upgrade to SQL Server 2005 after you have installed the Business Scorecard Manager Server Web service, you must set your default Web site to use ASP.NET 1.1. Otherwise SQL Server 2005 might change the version the Web site used to ASP.NET 2.0. To set your default Web site to use ASP.NET 1.1, enter the following command at the command prompt:

%SystemRoot%\Microsoft.NET\Framework\v1.1.4322 aspnet_regiis.exe -s metabase-path

where metabase-path is the path to your Web site, for example W3SVC/1/ROOT.

Business Scorecard Manager Web Parts Prerequisites

The following components are prerequisites for Business Scorecard Manager Web Parts in the order in which they should be installed:

1.      Microsoft Windows Server 2003 with SP 1

2.      Microsoft .NET Framework 1.1 with ASP.NET 1.1 enabled

3.      Internet Information Services 6

4.      Microsoft SharePoint® Portal Server 2003 or Microsoft Windows SharePoint Services 2.0: http://www.microsoft.com/windowsserver2003/technologies/sharepoint/default.mspx

SQL Server Reporting Services Prerequisites

The following components are prerequisites for SQL Server Reporting Services:

1.      Microsoft Windows Server 2003 with SP 1

2.      Microsoft .NET Framework 1.1 with ASP.NET 1.1 enabled

3.      Microsoft Internet Information Services (IIS) 6.

4.      SQL Server 2005 Reporting Services (For more information, see Installing Reporting Services: http://go.microsoft.com/fwlink/?LinkId=52932)

Note: If you install SQL Server Reporting Services and have already installed either Windows SharePoint Services or SharePoint Portal Server on the same computer, there is a known issue with their not functioning properly together. See Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services.

http://go.microsoft.com/fwlink/?linkid=52934

Business Scorecard Manager Server Database Prerequisites

Install SQL Server 2005 to set up your Business Scorecard Manager Server database.

Comments, suggestions or questions? Please reply below!