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 - v8.0 and lower) 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.

    ParameterDefinition

    SiteName

    Description:
    Specifies the name of your site.
    Allowed Values:
    One line of text (a string).

    Accepted:

    • Letters
    • Numbers
    • Spaces

    AdminUsername

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

    AdminPassword

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

    DatabaseProvider

    Description:
    This always the same value.
    Allowed Values:
    SQLServer

    Recipe

    Description:
    This is always the same value.
    Allowed Values:
    "AgilePoint - Master"

    DatabaseConnectionString

    Description:
    The connection string for the AgilePoint database.
    Allowed 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

    Description:
    (Optional) Gives the output of the orchard command execution.
    Allowed 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 NameDefinition

    database name

    Description:
    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.
    Allowed 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

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

    ConnectionString

    Description:
    The connection string for the AgilePoint database.
    Allowed 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

    Description:
    This always the same value.
    Allowed Values:
    SQLServer

    Status

    Description:
    This is always the same value. By default, the tenant is active.
    Allowed Values:
    Active

    CreatedOn / LastModifiedOn

    Description:
    A function that gets the system date.
    Allowed Values:
    Getdate()