New Enterprise 7 Installation
Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
•Please read this entire article carefully and plan appropriately before beginning.
•This article is for clients creating a new Enterprise 7 installation.
•Prior to installation, please review the release notes for hardware and software requirements and additional release information.
•Recursive triggers must be enabled for the database. This can be enabled under the Options tab of the database properties in SQL Server Management Studio.
•Microsoft SQL Server 2012, 2014, 2016 or Microsoft Azure SQL Database
•Microsoft® System CLR Types for Microsoft SQL Server for GEOGRAPHY data type
•Windows Server 2008 R2, 2012, 2012 R2, 2016
•IIS v7+ (see Figure A at the bottom of this article for details of IIS configuration)
•Microsoft .NET Framework v4 with ASP.NET (see figure below for details of .NET configuration)
•Supported browsers: Chrome, Firefox, Edge
•EQuIS Professional 7 must be installed prior to upgrading/installing EQuIS Enterprise. Installation and Upgrade.
1.Using EQuIS Professional, create the EQuIS Database (see Create New EQuIS Database (SQL Server and SQL Server Express)).
2.Create an Enterprise Service Account.
a.Connect to SQL Server Management Studio (SSMS).
b.Select Security> Logins.
c.Within Logins, right-click and select "New Login".
d.Navigate to the General tab, and create a name in "Login name".
i.Select SQL Server authentication. Create and confirm a password.
ii.Select the EQuIS database in "Default database".
e.Navigate to the Server Roles tab.
f.Navigate to User Mapping.
i.Select the EQuIS Database to map to.
ii.Select Database role membership and assign the following roles:
g.Select OK to save the settings.
3.Select the EQuIS database> Security> Users.
a.Confirm the Enterprise Service account created in Step 2 is present.
b.Login to SSMS using the newly created username/password to confirm that the credentials are valid.
Please follow the instructions in the EQuIS Professional article to Apply Network Licenses.
The EQuIS Enterprise 7 download links are available for download at the EarthSoft Community Center.
1.Download EQuIS Enterprise 7 installer (.zip) from the Downloads Dashboard (Products> EQuIS Enterprise> 7).
2.Extract the files downloaded in Step 1.
3.Run the Enterprise 7.exe file as administrator and step through the installation wizard.
4.Configure the database connection using the Service account credentials created in the previous section.
a.Browse to the installation \bin directory (e.g., C:\Program Files\EarthSoft\Enterprise7\bin).
b.Open the connectionStrings.config file with a text editor with administrator privileges.
c.Copy the example connection string from line 4 and place it between the quotes after connectionString in line 5.
d.Update the Data Source, username, password and database to point to the EQuIS database and database server.
Example Line 5:
<add name="localhost" connectionString="Data Source=localhost;User ID=username;Password=pwd;Database=demo;Pooling=true;" providerName="EarthSoft.Common.Data.SqlConnection" />
e.Save and close the file.
5.By default EQuIS 7 uses an SSL connection, however, this can be disabled if this is not required.
a.Browse to the installation folder (e.g., C:\Program Files\EarthSoft\Enterprise7).
b.Open the Web.config file with a text editor.
c.Find <httpCookies requireSSL="true" lockItem="true"/>.
d.Change it to <httpCookies requireSSL="false" lockItem="true"/>.
e.Save and close the file.
6.(Optional) Configure log4net.config. See Configure log4net for more information.
7.(Optional) Configure Windows Authentication (LDAP Authentication). See Using LDAP Authentication for more information.
8.Start the EQuIS Enterprise 7 Workflow service under Windows Services.
9.Open a supported web browser and navigate to the installed web application URL (e.g., https://equis-server/equis7/).
10. Login using an EQuIS Enterprise administrator account (default account is administrator/admin).
Figure A: IIS configuration for Enterprise 7