Purpose

Local Microsoft SQL Server 2012 or later. A user with SELECT permissions is sufficient for reading.

Connection fields

FieldRule and default valueExplanation
Server (name or IP address)
host		RequiredSet the value according to your service configuration.
Port
port		As configured
Default: 1433
Range: 1–65535		Set the value according to your service configuration.
Named instance (optional)
instance		As configuredFor a named instance, SQL Browser determines the port.
Database
database		RequiredSet the value according to your service configuration.
SQL Server user
username		RequiredSet the value according to your service configuration.
Connection encryption
encrypt		As configured
Default: yes		yes — Enabled, with certificate validation
strict — Strict (TDS 8.0, SQL Server 2022+)
no — Disabled
Trust the server certificate without validation
trust_server_certificate		As configured
Default: False		Only for test servers with a self-signed certificate.
Password
secret		Separate protected fieldThe secret is not displayed after saving. An empty field in an existing connection preserves its current secret.

Setup and validation

  1. Create a connection and give it a clear name.
  2. Complete required fields and the separate secret field.
  3. Run “Test” and read the diagnostics.
  4. Save the connection and select it in the appropriate flow block.

A successful test does not replace checking access to the required object and specific write mode.

Use in a flow

Server and account settings are stored in the connection. The specific object, fields and flow behavior are defined in the block. Go to data-handling rules →