Orchard CMS Installation Failed

If Orchard CMS installation fails when you are using the installation program, to install the Orchard CMS, do the procedure in this topic.

Prerequisites

How to Start

  1. On your AgilePoint Server machine, open the file (NX Portal installation folder) C:\Program Files\AgilePoint\AgilePointWebApplication\AgilePointPortal\bin\orchard.exe

Procedure

  1. Run this command, using this format:
    setup /SiteName:"[Site name]"/AdminUsername:Admin/AdminPassword:Password
             /DatabaseProvider:SQLServer/Recipe:"AgilePoint - Master"
             /DatabaseConnectionString:"Data Source=[database server name or address];
             Initial Catalog=[database name]; Persist Security Info= True; Integrated Security=SSPI"
             /verbose:true

    For this command, use the values in the table to replace the items in [brackets]. Brackets indicate variables. When you enter the command, do not use these brackets.

    Parameter Definition

    SiteName

    Function:
    Specifies the name of your site.
    Accepted Values:
    One line of text that can have spaces.

    AdminUsername

    Function:
    This is always the same value, this is used anywhere after the installation. This is just required for orchard installation.
    Accepted Values:
    Admin

    AdminPassword

    Function:
    This is always the same value, this is not used anywhere after this installation. This is just required for orchard installation.
    Accepted Values:
    Password

    DatabaseProvider

    Function:
    This always the same value.
    Accepted Values:
    SQLServer

    Recipe

    Function:
    This is always the same value.
    Accepted Values:
    "AgilePoint - Master"

    DatabaseConnectionString

    Function:
    The connection string for the AgilePoint database.
    Accepted Values:
    "Data Source=[database server name or address]; Initial Catalog=[AgilePoint database name]; Persist Security Info= True; Integrated Security=SSPI"

    For the value of Integrated Security, use these values:

    • SSPI - This value represents Windows security.
    • User ID and Password - If you use SQL server authentication, enter your SQL server user name and password.
    Example:
    • Windows security - "Data Source=Demo-3; Initial Catalog=APPortalDB4; Persist Security Info=True; Integrated Security=SSPI"
    • SQL Server Authentication - "Data Source=Demo-3; Initial Catalog=APDefaultTenantDB3; Persist Security Info=True; User ID=sa; Password=sa"

    Verbose

    Function:
    (Optional) Gives the output of the orchard command execution.
    Accepted Values:
    • true
    • false
  2. Insert the default tenant in the AgilePoint NX Portal database using this query.
    INSERT INTO [database name].[dbo].[AgilePoint_Portal_Core_ShellSettingsRecord] (
      [Name],
      [ConnectionString],
      [DataProvider],
      [Status],
      [CreatedOn],
      [LastModifiedOn]
    ) 
    VALUES (
      'DEFAULTTENANT',
      'Data Source=Demo-3;Initial Catalog=APDefaultTenantDB3;Persist Security Info=True;Integrated security=SSPI',
      'Microsoft SQL Server',
      'Active',getdate(),getdate()
    )
    

    For this command, use the values in the table to replace the values in the VALUES clause. In this query string, in most cases the [brackets] represent variable names, but the variable values do not use brackets. The exception is the database name.

    Field Name Definition

    database name

    Function:
    The name of the AgilePoint database. Note that other values in this command string are entered in a name/value format, where the name is in the INSERT INTO clause, and the value is in the VALUES clause. However, the database name is entered in the INSERT INTO phrase.
    Accepted Values:
    A valid AgilePoint database name, which is one line of text with no spaces.

    The [brackets] for this value are literal, so enter the value like [MyDatabase].

    Name

    Function:
    This always the same value, a standard default name we are giving.
    Accepted Values:
    DEFAULTTENANT

    ConnectionString

    Function:
    The connection string for the AgilePoint database.
    Accepted Values:
    "Data Source=[database server name or address]; Initial Catalog=[AgilePoint database name]; Persist Security Info= True; Integrated Security=SSPI"

    For the value of Integrated Security, use these values:

    • SSPI - This value represents Windows security.
    • User ID and Password - If you use SQL server authentication, enter your SQL server user name and password.
    Example:
    • Windows security - "Data Source=Demo-3; Initial Catalog=APPortalDB4; Persist Security Info=True; Integrated Security=SSPI"
    • SQL Server Authentication - "Data Source=Demo-3; Initial Catalog=APDefaultTenantDB3; Persist Security Info=True; User ID=sa; Password=sa"

    DatabaseProvider

    Function:
    This always the same value.
    Accepted Values:
    SQLServer

    Status

    Function:
    This is always the same value. By default, the tenant is active.
    Accepted Values:
    Active

    CreatedOn / LastModifiedOn

    Function:
    A function that gets the system date.
    Accepted Values:
    Getdate()