Configure the ODBC connection
NetBackup handles the encryption settings of an ODBC connection from a NetBackup client to a target SQL Server instance. These settings are configured in the host properties for the connecting client and can only be configured with the hostProperties API endpoint or the nbsetconfig command.
Note:
The RBAC role does not have permissions to edit the host properties. Alternatively, workload administrators can log on locally to the host and use the nbsetconfig command to make the host property changes.
ODBC connections are created using an ODBC connection string. This string is made up of a list of key-value pairs that changes the connection's behavior depending on the key-value pair.
Table: hostProperties API endpoint parameters for ODBC connections
Parameter | Description |
|---|---|
| Whether to encrypt the connection using TLS. For NetBackup clients that are updated to 10.4 or later, the SQL Server ODBC connections from the client to a target SQL Server instance are encrypted by default. |
| Whether to trust the target SQL Server instance's certificate. For 10.4 and later clients, |
| The name of the supported SQL Server ODBC driver to use during the connection. The value can be one or many individual driver names. List driver names in the order of preference. Or, set the value to The driver The available driver values are as follows: "SQL Native Client" "SQL Server Native Client 10.0" "SQL Server Native Client 11.0" "SQL Server" "ODBC Driver 11 for SQL Server" "ODBC Driver 13 for SQL Server" "ODBC Driver 17 for SQL Server" "ODBC Driver 18 for SQL Server" "OLDEST" "NEWEST" |
The following example uses the host properties API endpoint to enable encryption, trust the target client certificate, and indicates NetBackup should use the driver "SQL Server". If that driver is not available, then NetBackup should use "ODBC Driver 17 for SQL Server".
PATCH https://{{primary-server}}/netbackup/config/hosts/{{client-host-id}}/
host-properties?fieldset%5BhostProperties%5D=clientMssql
Body:
{
"data": {
"type": "hostProperties",
"id": "{{client-host-id}}",
"attributes": {
"clientMssql": {
"trustServerCertificate": true,
"preferredODBCDriver": [
"SQL Server",
"ODBC Driver 17 for SQL Server"
],
"encrypt": true
}
}
}
}