Create a server to save connection settings (Local)

Create a server to save connection settings (Local)

The Servers feature allows for the centralized storage of connection parameters (server address, credentials, database engine, etc.) . The location can be local or remote, and the supported databases are: SQL Server, SQL Express, MariaDB, PostgreSQL, and MySQL.

To create or modify a Server :
  1. File menu, then Organizations .
  2. On the Organizations page, click the context menu and select Servers :

  3. On the Servers page, click the New button At the bottom left of the page, to create a new server, or double-click on an existing server to edit it:



  4. On the Server page, fill in the required fields:



    1. Cheel Account : The Cheel account in which the server is created.
    2. Name : Name used to identify this server configuration.
    3. Database engine : SQL Server, MariaDB, MySQL, or PostgreSQL. In this example, SQL Server Express is used.
    4. Server : The name or IP address of the computer or server on which the database engine is installed, followed by the database instance. In our example, the SRV-DATA\SQLEXPRESS instance corresponds to the default name when installing SQL Server Express on a machine named SRV-DATA.
    5. Port: Optional, specify a database manager port number if it is different from the default port.
    6. Additional settings : Optional, additional connection settings.
    7. Username and Password : Credential information. The button to the right of each field allows you to enter your credentials.
    8. Allow the creation of organizations : Enabling this checkbox allows the creation of organizations on this Server.

  5. Confirm the Server by clicking OK .
Info
To create an organization connected to your local database manager:
In the Database Location step of the Organization Creation Wizard, select Custom Server (Local) as the location, and then choose the relevant server :



For more information on creating an organization, click here .