Orchard CMS Installation Failed

Prerequisites

• AgilePoint NX PrivateCloud (on-premises).
• You installed AgilePoint NX, but the installation of the Orchard CMS failed.

How to Start

1. On your AgilePoint Server machine, open the file [AgilePoint Portal installation folder]\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 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()