Orchard CMS Installation Failed

Prerequisites

• AgilePoint NX OnPremises or AgilePoint NX PrivateCloud.
• You installed AgilePoint NX, but the installation of the Orchard CMS failed.

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.

   Parameter	Definition
   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 Name	Definition
   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()