Installing the Celiveo Web Admin

!IMPORTANT NOTE: SQL Server® 2016 SP1 is not supported on Windows 7 and Windows 2008 R2 Operating systems. For Windows Servers running on Windows Server 2008 R2 OS, it is recommended to install a lower version of SQL Server (preferably SQL Server® 2012 Express) and then follow the instructions.

The Celiveo 8 Web Admin installer package comprises of the following components:

• Printer Discovery Agent
• Celiveo Virtual Printer deployment package
  

The new tracking and reporting tool Track- Green Saver (TGS 10) is a stand-alone installer package. This should be installed in the Server right after Web Admin installation. The instructions for installing TGS 10 can be found in here.

Before you start, ensure the following:

• Both the application and database servers are in the same domain.
• IIS is installed on the secondary database if there is any, with version 5.1 minimum.
• “HTTP Activation” is enabled in the Windows Server Features
• SQL Authentication is set to Mixed Mode.
• The SQL Server database is configured to allow remote connection:
  • The SQL Server Browser Service is running.
  • TCP/IP protocol for the SQL Server is enabled.
  • The firewall allows remote connection

Follow these steps to install Celiveo Web Admin on Windows Server.

1. Start Installation
2. Install SQL Server Express
3. Install Celiveo 8
4. Finalize Installation
5. Change Database Password After Installation

1. Start Installation

1. Copy the Celiveo Web Admin installer package to the desktop. You can download the latest version from Downloads.
2. Select the installer and right-click on [Run as administrator].

2. Install SQL Server Express

1. In the welcome window, select [Install Microsoft SQL Server® 2016 SP1 Express]. If SQL Server already exists in your machine, do not select this option.
2. Define the password for the account with System Administrator (role) access on the SQL server.
3. Click [Start Installation].
   
4. Follow on-screen instructions to install SQL Server® 2016 SP1 Express.
5. When prompted to reboot the machine, click [Yes].

3. Install Celiveo 8

1. To continue the installation after the machine reboots, click [Next].
   
2. Be informed of the license terms and conditions. To continue installation, select the checkbox to accept and click [Next]. To cancel, click [Cancel].
3. If required, edit the file location and click [Next].
5. Select the SQL Server IP address/hostname in the [Database Server] list.
6. 1. Options:
      1. Select [Encrypted Connection] checkbox to enable secured communication with SQL Server.
      2. Select [Multi Subnet Failover] checkbox to enable connection to (Always On) Availability Groups in case of a failover in a multi-subnet environment.
         p(banner important). Important: If you are intending to use Multi-SQL configuration, it is highly recommended to provide an IP address/hostname at the [Database Server].

*Note: The default database is \SQLEXPRESS

*Note: To connect to a SQL Server that uses a different port use Server Name\Instance Name, Port. eg: celiveo\Celiveo_SQLDB,5594

*Note: System Administrator account is required only at the time of installation. You may delete/disable this account after installation. See OS and SQL rights to install and use Celiveo to view permissions used for TGS Service account and Celiveo database accounts.

7. Click [Test Connection].
8. Once the connection test is successful, click [Next].
9. In the IIS Configuration window, enter the [HTTP Port] and [HTTPS Port] details. The default values are provided as 80 and 443 respectively. If required, change the port details and click [Next].
   

4. Finalize installation

10. When prompted, click [Install].
    
11. When prompted to exit the Setup Wizard, click [Finish].
    
    The Celiveo Web Admin icon is added to the desktop.

5. Change database password after installation

For security purposes, it is recommended to change the default password of SQL Server right after installation. You can update the password on the SQL server for Celiveo database (CeliveoDB) account and then update the same password for the database profile in Web Admin.

On SQL Server:

1. Go to Security > Login.
2. Right-click on CeliveoDB account and choose Properties.
3. Go to General page.
4. Set a new password for CeliveoDB in [Password] field
5. Re-enter the password in [Confirm Password] field.
6. Click [OK].
   

On Web Admin

1. On Celiveo Web Admin Home page, click the Setup icon.
2. Choose DB settings tab.
3. On the SQL DB profile row, click the Edit icon.
4. Update the [DB password] with the new password set for CeliveoDB account.
5. Click [Save].
   

©2024 Celiveo Pte Ltd – All Rights Reserved