ROBOTILL HELP

SQL Server managed by an IT provider

For the usual installation, let ROBOTILL Setup install the database software. These steps are for an IT provider who installs or manages SQL Server separately.

Prepare the database and connection

  1. Install ROBOTILL, then open Windows Start > ROBOTILL > Database Setup.
  2. Choose Advanced / support > Set up an existing SQL instance.
  3. For SQL Server on this computer, keep SQL Server is on this computer ticked and enter just the instance name, for example SQLEXPRESS. Use MSSQLSERVER for the default instance. Keep the database as redtill. No connection prefix or port is needed.
  4. Use an authorised Windows or SQL administrator connection and keep the organisation's encryption and certificate policy. The SQL application login requires mixed mode (SQL Server and Windows authentication). Choose Create new database; setup verifies and saves the connection. This refuses to overwrite an existing database.
  5. For an existing database needing migration, use Other support tools > Migrate Existing Installation. To deliberately start over, use Recreate database - start from scratch; this deletes existing data after confirmation.
  6. For Windows-group application access instead, the provider prepares the ROBOTILL database and uses Configure Customer-managed Windows Authentication with an approved group and an ordinary account for validation. This option does not convert a database already using another application identity.
  7. After configuring and verifying a network connection, use Other support tools > Export Connection Settings for an IT-managed Installation to supply a setup file to the other computers.

Administrator access

The application uses restricted database access. Maintenance requires separate SQL administrator authority. Leave the exclusive ROBOTILL ownership option unticked for a shared or customer-managed instance.

Network access

The IT provider configures the SQL endpoint, firewall and Windows group membership where needed. ROBOTILL does not automatically change these settings for a customer-managed instance.

The local shared-memory connection cannot be used by other computers. Once network access is ready, use Server name or address changed, untick SQL Server is on this computer, enter the reachable address (for example MAINPC,11433 with the actual configured port), and choose Test and save server address before exporting. See choosing the SQL connection.

See ROBOTILL Setup - Advanced tools for all maintenance options.