MSSQL_ODBC_PREFERRED_DRIVER for SQL Server clients
The name of the supported SQL Server ODBC driver to use during the connection.
Table: MSSQL_ODBC_PREFERRED_DRIVER information
Usage | Description |
|---|---|
Where to use | On NetBackup SQL Server clients. |
How to use | Use the nbgetconfig and the nbsetconfig commands to view, add, or change the option. For information about these commands, see the NetBackup Commands Reference Guide. The default value is To automatically select the oldest or newest driver, use the following format: MSSQL_ODBC_PREFERRED_DRIVER = OLDEST | NEWEST For specific driver names, create a separate entry for each driver name. MSSQL_ODBC_PREFERRED_DRIVER = ODBC Driver 18 for SQL Server MSSQL_ODBC_PREFERRED_DRIVER = ODBC Driver 17 for SQL Server |
Equivalent NetBackup web UI property | No equivalent exists in host properties. A user with the necessary RBAC permissions can also use the hostProperties API endpoint to configure this setting. See the NetBackup for Microsoft SQL Server Administrator's Guide for details. |
See MSSQL_ODBC_ENCRYPT_CONNECTION for SQL Server clients.
See MSSQL_ODBC_TRUST_SERVER_CERTIFICATE for SQL Server clients.