Microsoft SQL Server
SQL commands targeting a SQL Server database
instance.
Type:
sql-server
Configuration
Name | Required | Description |
MSSQL_CONNECTION_URI | yes | The server name which will be used to connect to the SQL instance,
format: [protocol:]server[instance_name][,port] |
MSSQL_USER | yes | The database username |
MSSQL_PASS | yes | The database password |
MSSQL_DB | yes | The name of the database instance |
FIELD_SEPARATOR | no | Defaults to table output, using other character will suppress
spaces |
Examples
Connection URI:
MSSQL_CONNECTION_URI=tcp:192.168.10.110,1490
MSSQL_CONNECTION_URI=192.168.10.110
- defaults to tcp and port 1433