· 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