EPM Live Installation - Deploy Solution Files & Create EPM Live Database

You will manually deploy the EPM Live solution files into SharePoint.

Run Powershell Command to Deploy Solution Files

Open SharePoint Powershell. Run the following Powershell command:

Note: This will deploy the solutions to the specified web app.  Be sure to replace the URL with your URL.


Install-SPSolution -Identity workenginecore.wsp -GACDeployment -CompatibilityLevel {14,15} -webapplication https://company.epmlive.com -force

Install-SPSolution -Identity workenginewebparts.wsp -GACDeployment -CompatibilityLevel {14,15} -webapplication https://company.epmlive.com -force

Install-SPSolution -Identity workenginetimesheets.wsp -GACDeployment -CompatibilityLevel {14,15} -webapplication https://company.epmlive.com -force

Install-SPSolution -Identity workenginedashboards.wsp -GACDeployment -CompatibilityLevel {14,15} -webapplication https://company.epmlive.com -force

Install-SPSolution -Identity workenginepfe.wsp -GACDeployment -CompatibilityLevel {14,15} -webapplication https://company.epmlive.com -force

Install-SPSolution -Identity workengineforms.wsp -GACDeployment -CompatibilityLevel {14,15} -webapplication https://company.epmlive.com -force

Install-SPSolution -Identity workenginereporting.wsp -GACDeployment -CompatibilityLevel {14,15} -force

Install-SPSolution -Identity workengineworkplanner.wsp -GACDeployment -CompatibilityLevel {14,15} -force

Install-SPSolution -Identity workenginesynch.wsp -GACDeployment -CompatibilityLevel {14,15} -force

Verify Solutions

Installing EPM Live creates a number of new solution files in SharePoint.  Make sure these solutions installed properly, and were deployed to the correct Web Application.  In Central Administration, click the Manage Farm Solutions link under the Farm Management heading of System Settings.  Make sure that all solutions listed in the previous step have a status of “Deployed.”  If they are not globally deployed, ensure that they have been deployed to the web application that EPM Live is being installed on only with the exception of the "workenginecore.wsp" solution file.  This solution is deployed to the central administration web application as well.

Note: If they are not globally deployed, ensure that they have deployed to the EPM Live Web Application.

Create New Database

  1. Navigate to SharePoint Central Admin.  
  2. Open General Application Settings.  
  3. Open WorkEngine Administration.  
  4. Open Application Settings.
  5. Click the Create Database button to create the EPM Live Database.

Create Database Name

  1. Enter the Server Name.
  2. Enter a Database Name. It is recommended to call it “EPM Live.”
  3. Do not enter a Username or Password.  Leave the fields BLANK.

Note: If this page errors, you may need to use a SQL authenticated account to create the database.  The Username and Password fields on this dialogue box only accept SQL Authenticated credentials, not Windows Authenticated.  This account will need to have Sysadmin rights in SQL to create the database.  Once the database is created, you can remove the sysadmin rights and change the connection string to use Trusted_Connection as in the example.

New Database Connection String



Please sign in to leave a comment.