Serverutil
  • 17 Jun 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Serverutil

  • Dark
    Light
  • PDF

Article summary

This standalone configuration utility which is shipped with the Liquit Server product, can be used to register the local device as a new server within an existing Liquit Workspace database and to change the Server.json file.

There are several actions and parameters which you can combine:

setcredentials

The setcredentials action is used to update the database or Windows service credentials and can be combined with the following options:
--database- Update database credentials in Server.json.
--service- Update Windows service credentials in Server.json and service.
--username- The username to use; it will prompt for input, if not specified.
--password- The password to use; it will prompt for input, if not specified.

Example: serverutil.exe setcredentials --username "sa_liquit" --database

update

The update action is used to upgrade the database schema and can be combined with the following options:
--database - Update database schema.
--validate - Check if a supported upgrade path is available for the schema.
--connectionString - Database connection string to use, will use Server.json, if not specified.
--username - The username to use; it will use credentials from Server.json, if not specified.
--password - The password to use; it will use credentials from Server.json, if not specified.

Example: serverutil.exe update --database --validate

register

The register action is used to register the local server within the database and can be combined with the following options:
--connectionString - The database connection string to use; it will use Server.json if not specified.
--username - The username to use; it will use credentials from Server.json, if not specified.
--password - The password to use; it will use credentials from Server.json, if not specified.
--name - Server name to use within Liquit Workspace; it will use the hostname, if not specified.

Example: serverutil.exe register --connectionString "Data Source=sql.liquit.com;Initial Catalog=Liquit;Integrated Security=False" --username "sa_liquit" --password "password"

config

The --config option is used to customize a Server.json configuration file. For example, if you have a JSON in another, location you can specify the path to the JSON and use this option to test it. You can combine this option with any of the following options:

setup

The setup action is used to initialize an empty database and can be combined with the following options:

--connectionString - The database connection string to use; it will use Server.json if not specified.
--feature - Specify which database type to create; valid parameters: Events, Insights, System. The default value is System.
--virtualHost - The Virtual Hostname to use when creating a System database. It is required for the System type database.
--username - The username to use; it will use credentials from Server.json if not specified.
--password - The password to use; it will use credentials from Server.json if not specified.


Was this article helpful?