SQL Server
Specific parameters for establishing Microsoft SQL Server connections.
General Information:
| Type ID | Module | Category |
|---|---|---|
11 |
database |
database |
SqlServerConnectionParams
Parameters:
No parameters.
Input Parameters:
| Field | Type | Required | Description | Default value | Examples |
|---|---|---|---|---|---|
host |
str | ❌ | Host name or IP address of the database server | ```` | 200.00.25.547, devdb.com |
port |
int | ❌ | Database server port | 5432 |
5432 |
username |
str | ❌ | Username for authentication | ```` | user |
password |
str | ❌ | Password for authentication | ```` | password |
database |
str | ❌ | Name of the database to connect | ```` | mydb |
use_ssl |
bool | ❌ | Whether to use SSL for the connection | False |
False |
Example:
{
"host": "localhost",
"port": 1433,
"username": "sa",
"password": "password",
"database": "mydb",
"use_ssl": false
}
Notes:
SQL Server supports Windows and SQL authentication.