RPS Node Requirements

With the Relational Population Service (RPS), the following 64‑bit SQL Server ODBC drivers must be used for the SQL Server versions.

• Azure SQL Database (consult the Microsoft Azure documentation for the versions and features that are supported)

• Azure SQL Managed Instance (consult the Microsoft Azure documentation for the versions and features that are supported)

• Microsoft SQL Server 2022 requires ODBC Driver 18 for SQL Server

• Microsoft SQL Server 2019 requires ODBC Driver 17 for SQL Server or later (ODBC Driver 18 for SQL Server is recommended)

• Microsoft SQL Server 2016 requires ODBC Driver 13 for SQL Server or later (ODBC Driver 18 for SQL Server is recommended)

• Microsoft SQL Server 2014 requires SQL Server Native Client 11.0 or later

• Microsoft SQL Server 2012 requires SQL Server Native Client 11.0 or later

• Microsoft SQL Server 2008 requires SQL Server Native Client 11.0 or later

The sqlcmd SQL Server utility must be installed on the RPS node to use the default (recommended) sqlcmd to execute SQL scripts.