How do I deploy multiple instances of BSM (Useful for a Single Instance too)

Moving Your BSM Database

·         Create a SQL Server Database

·         Backup your test BSM database

·         Create a new database in your production environment

·         Restore the test BSM database

·         Choose to overwrite the database in Restore Options

·         Repeat backup and restore for any cubes used

·         Backup and restore will set security permissions

·         In a web farm environment you only need one BSM database

Create a new BSM IIS Site

·         Create a new BSM IIS Website

·         Create a directory for IIS to use

·         Copy the three files from your test BSM website

·         Modify web.config with Notepad

·         Change the “Data Source” to point to your new BSM SQL Server

Use the IIS Admin to create a new site

·         Point to the file location you just created

·         Select a unique web port

·         Remove Anonymous access

·         Select “Execute” website execute permissions

·         Change the Application Pool to use the SharePoint Application Pool (Home Directory tab)

Create an IIS site for SharePoint

·         Create an IIS Site for SharePoint to use

·         Create a file system directory for the site

·         Create an new website in the IIS Admin

·         Use a unique port number

·         Point to the empty file system directory

·         Select “Execute” web site permissions

·         Remove Anonymous access

Extend SharePoint

·         Extend SharePoint to your new site

·         Use the SharePoint Administrator

·         Virtual Server Configuration

·         Extend Virtual Server to the IIS Site

·         Use the existing SharePoint Application Pool

·         Start your SharePoint site and apply your SharePoint Template

Add the Webparts

·         Locate the IIS files on your test SharePoint directory

·         Locate the folder in the root called “WPCATALOG”

·         Contains two DDL’s

o    Microsoft.PerformanceMangement.Scorecards

·         Copy the folder and files to your new SharePoint directory

SharePoint Web.Config

·         Open on your test SharePoint system the web.config file

·         Copy the entire line under <SafeControls>

·         Assembly Micrososft.PerformanceManagement.Scorecards.Webpart

·         Copy the entire line under <appSettings>

·         Key BPM.ConnectionString

·         Paste both into the Production web.config

Add to SharePoint Web Gallery

·         In IE, open the new SharePoint site

·         Select “Site Settings”

·         Select “Upload Web Parts”

·         Select “Upload multiple file”

·         Add the two Micrososft.PerformanceManagement.Scorecards.Webpart

Helpful Reminders

·         To publish updates you must point the Business Scorecard Builder to your new BSM IIS Site

·         Your BSM Site Application Pool needs to use the same Application Pool as SharePoint

·         Ensure that Databases and Cubes have the correct security permissions

·         Typically Network Services

·         Database Roles: BPDeveloper & BpmViewer

·         Look in the Event Viewer Log for any errors

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s