New install preparation
System & Network Requirements
We recommend you run Earnie IQ in its own instance of SQL Server and over a 100 megabit network.
The name of the SQL Server instance MUST NOT contain the word ‘Database’
The Installation Process
Installing Earnie IQ is essentially a two-stage process; Server Side Installation and Client Side Installation. However it is essential that the SQL Server is configured correctly prior to installation and that plans are put in place to keep the product running efficiently.
| Stage | Description |
| SQL Server Installation | Installation of Microsoft SQL Server |
| SQL Server Configuration | Set SQL Server to allow installation of Earnie IQ |
| Earnie IQ Server Side Installation | Installation of Earnie IQ Server side components |
| Install Clients | Installation of Earnie IQ Clients (including Timesheet Central and Timesheet Remote if applicable) and licensing |
| Post Installation |
Plan for general housekeeping including setting up a maintenance plan and a backup schedule |
Preparing for a New Installation
Microsoft SQL Server (System requirements) must be installed on a server on your network before you can install Earnie IQ Server. It is beyond the scope of this document to cover the installation of SQL Server itself, however, it is necessary to document how the SQL Server should be configured in order for Earnie IQ to install and operate correctly.
Earnie IQ may not function correctly unless the following requirements are met:-
SQL Server Authentication Mode
Earnie IQ utilises SQL Server authentication therefore the SQL Server needs to be configured with Mixed Mode Authentication.
For more information on checking the authentication mode of your SQL Server, see Checking the Server Authentication Mode.
Service Start-up Properties
The SQL Server service and the SQL Server Agent service need to be run under an administrative user account. You will need to identify a Windows account that has administrator rights on the machine where SQL Server is running. We recommend you follow Microsoft’s guidelines and set the SQL Server service and SQL Server Agent to run using this account. We also recommend that you set the Start-up type of both of these services to ‘Automatic’.
For more information on setting service properties, see Setting Service Startup Accounts.
Proxy Account
During the installation process you will be asked for the details of a Windows account that can be used as a SQL Server proxy. The SQL Server Agent uses the proxy account to run database update jobs. This account must have Windows administrator rights to the SQL Server machine and should be set up before you install Earnie IQ Server for the first time. You will need to identify an account (or create a new one) that has administrator rights on the machine where SQL Server is running.
We recommend creating a new account with the name “SQLProxy” or identifying an account that can be used exclusively for this purpose.
If you wish, you can use the same account that you used for the SQL Server services, or you can create a new account specifically for the purpose. You may also want to check with the SQL Server administrator whether a proxy account is already assigned, in which case you should use the details of this account.
Take a careful note of the account details including the name, domain and password, as you will need these during the Earnie IQ Advanced Server installation process.
Pre-Installation
To install the server-side of Earnie IQ you will require the following information:
-
The name of the SQL Server instance where the Earnie IQ databases are to be installed.
-
A valid login to the SQL Server. This will either be the “sa” account and password or an administrator login to Windows on the SQL server.
-
The location of where you want to store the Earnie IQ SQL Server database data, transaction logs and backup files. (i.e. somewhere on the SQL Server).
-
Optionally, the proxy account details.
Next: Server install