Welcome to Office Zealot Sign in | Join | Help

Installing Business Scorecard Manager with SQL Server 2005

OK, I spent the better part of today putting together a Virtual PC image of a BSM/SQL'05 installation.  I've received a few questions about this configuration and wanted to make sure I got the steps right.  Below are my notes and comments.

1. Created a Virtual PC 2004 Image running under 512MB RAM

2. Installed Windows 2003 Server Enterprise Edition

3. Applied W2K3 SP1

4. Installed SharePoint Portal Server 2003

5. Applied WSS SP2 and SPS SP2

6. Installed SQL Server 2005 Standard Edition

Few side notes --- (1) You CANNOT install SharePoint with SQL'05 Developer Edition... won't work.  Go with Standard.  (2) The SQL'05 installation throws a warning that “minimum hardware requirements are not met”.  This does not impede the installation but you should note that 512MB is not good enough... (3) The SQL'05 installation that comes down from MSDN is on two cd's.  The second one includes the Management Studio.  I got messed up when the first cd install finished and I couldn't find Management Studio (4) While on the subject of installations on a Virtual PC... don't try the installs from cd.  Copy the files to the main machine file system and share it with the virtual environment.  There are known issues with large installations via cd.

7. Configured SPS to use the SQL instance

8. Created a Portal

(for the BSM pre-requisites)

9. Ran SQL Server 2000 Analysis Services SP4.  This downloaded files to the server.  Found and ran ptsfull.exe

note -- if you don't do this, the BSM server install will fail with a “Microsoft OLE  DB Provider for OLAP Services (MSOLAP) 2000 SP4“ error

10. Installed MSXML 4.0 with SP2

11. Installed ADOMD.NET 8.0

12. Installed Business Scorecard Manager (Builder and Server)

Works like a charm!

Published Tuesday, December 27, 2005 3:03 PM by Mauro

Comments

Wednesday, December 28, 2005 4:33 PM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

THANKS! You saved me HOURS of pain and suffering... Much appreciated!
Monday, January 02, 2006 8:43 AM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

just a quick note:

we've a development enviroment where sharepoint is installed in sql'05 developer edition and it seems fully working.
Already deployed some scorecards on it.
I'm talking about beta2
Tuesday, February 21, 2006 8:12 PM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

Shall I change Step 6,7,8 to Step 7,8,6
Friday, March 31, 2006 3:17 AM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

If you're building a demo inside a VPC and not doing too much with SharePoint itself, you can leave SharePoint on WMSDE to avoid any SQL clashes (also saves you from installing or connecting to AD, if resources are limited).

I've just posted some notes on installing and then creating your first scorecard here: http://www.joiningdots.net/blog/2006/03/installing-business-scorecard-manager.html

To Sophia: you can't change steps 6,7,8 to 7,8,6 - you can't configure SPS to point to an instance of SQL until you've installed SQL.
Thursday, May 04, 2006 1:09 PM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

Can you use Windows Server 2003 Standard Edition, instead of Enterprise Edition
Tuesday, June 06, 2006 10:47 AM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

Hi Mauro, I saw in other page that Notification Services 2005 dont work fine with BSM, and the option is install SQL 2000 with all your service packs and also Notification 2000.

Is that true? or I can get your steps and after installas Notification 2005?

Regards,
Giulio
Thursday, July 20, 2006 4:41 PM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

Install the service packs (SP2) for Sharepoint Services and Sharepoint Portal Server and then run the installation against SQL Server Developer Edition. It works fine.
Monday, July 24, 2006 4:37 AM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

Hi,
Can you please recommend me some good books on Business ScoreCard Mananger and Share Point Server.

I am very new to the topic and my task is to build KPIs using Sharepoint.

Regards
jignesh_desai@hotmail.com

Friday, July 28, 2006 11:00 AM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

THANK YOU VERY MUCH!!!!

The tip on extracting PSTFULL (I actually used PSTLITE) from the SQL 2k SP4 package was invaluable! That was the real life saver.

Up and running now, tks to you!

Alex
Friday, July 28, 2006 2:16 PM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

Hi

We are building a scorecard to report the sales. We need the rows to display the time, ie., by year, quarter and month. And the columns to display the autaul sales and its target values for a particular time dimension.My datasource is SSAS cubes. Is there a way by which I get the Actual and the target value for a year and by drilling it will I get the values for a quarter for a particular year, and by drilling through the particular quarter, will I get the values for the month of that particular year and quarter.I get all the values in the format that I wanted in my cube.
Can I achieve the same using Business scorecard.

I have created 3 KPI's. One for year, one for Quarter and another for Month. After adding them to my scorecard and editing them, when I publish it to share point I get the correct values for the actuals and targets for a particular year, but for a quarter, the aggregation is done for all the years, ie., for 1st quarter it aggregates for all the years and similarly for te oter 3 quarters..Similarly for month, it aggregates the 1st month value for all the years and so on.. And moreover I don’t get a drill through..

Can you suggest me how to solve my problem


Wednesday, August 02, 2006 1:23 PM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

Por favor necesito uinformacion acerca del uso de BSC Manager lo he instalado bien con el SQL 2000 SQ2 y Sharepoint portal server 2003 esta funcionando muy bien pero necesito algun tutorialo algopara poder comprender mejor el funcionamiento de esta herramienta. micorreo es johana85@gmail.com. Gracias de antemano :D
Wednesday, August 09, 2006 8:45 AM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

We have Installed Businesss Scorecard and facing problem while connecting it to the SQL Server 2005 following error is reported

“The Business Scorecard Manager server could not connect to the data source. Verify all of the required data has been entered and the required connection information is correct”

We have created Sharepoint Site on a port- 90, while IIS Server admin is on port- 80.

We have given permission in Database for User: “NT AUTHORITY\NETWORK SERVICE”.


Still Builder is NOT able to connect to Server,

It would be great help if somebody points out where is the error.
Thursday, October 26, 2006 8:28 AM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

I'm following so far, but installed WIN2K3 R2, SQL 2005, and WSS SP2 instad of Portal Server.

Should I extend a virtual server, or can I just create a top level site?

Also, I installed the SQL 2K SP4. It created a folder, but I cannot find either pstfull or pstlite. Any thoughts?

Thanks in advance.

__rick
Wednesday, November 01, 2006 8:40 PM by Anonymous

# re: Installing Business Scorecard Manager with SQL Server 2005

Hey all,

Here is what I learned from this article...

I installed SQL Server 2005 and Analysis Services 2000. You must install Analysis Services 2000 SP4 and MSXML 4.0 SP2 prior to installing BSM. If you did not this, uninstall BSM and at least re-install MSXML 4.0 SP2. Interestingly with SQL Server 2005 installed, BSM did not show an error regarding MSXML 4.0SP2 so that means it will seem like you can successfully install but it won't actually work.
Thursday, April 12, 2007 3:13 AM by REb

# re: Installing Business Scorecard Manager with SQL Server 2005

Hi !

Do you have any cases of deploying MS BSM + MS AS 2000 on servers with “Locale Identifier” parameter differ from English?

The main issue is if we using not English “Locale Identifier” (For example with Russian: Locale Identifier=1049) we can’t see any data in Scorecards. Also, in Event Log we can see these records:

Event Type:        Error

Event Source:    Microsoft Office Business Scorecard Manager 2005

Event Category:                None

Event ID:              0

Date:                     4/4/2007

Time:                     11:18:19 AM

User:                     N/A

Computer:          PORTAL

Description:

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection+IXmlaClientProviderEx.DiscoverWithCreateSession(String requestType, Boolean sendNamespaceCompatibility)

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.RetrieveSchemaRowsets(Boolean createSession)

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToIXMLA(Boolean createSession)

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()

  at Microsoft.PerformanceManagement.Scorecards.Client.AdomdConnectionPool.GetConnection(String connectionString)

  at Microsoft.PerformanceManagement.Scorecards.Server.PmServer.QueryRelatedMember(Guid dataSourceId, String self, MemberRelationship relationship)

Wednesday, April 25, 2007 7:47 PM by “You are making my point!” » Business Scorecard Manager Server and 64-bit MOSS

# “You are making my point!” » Business Scorecard Manager Server and 64-bit MOSS

PingBack from http://www.hyperbina.com/blog/?p=25

Wednesday, June 27, 2007 8:35 AM by The Boiler Room - Mark Kruger, Microsoft SharePoint MVP

# Free SharePoint Web Parts (3rd Party)

Free SharePoint Web Parts (3rd Party) Konrad Brunner - UGS's Web Parts (broken link 8/25) Document

Anonymous comments are disabled