Requirements for RPS Nodes

Product Information > JADE Installation and Configuration Guide > Chapter 1 - Installing JADE under Windows > Requirements for RPS Nodes

Requirements for RPS Nodes

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

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 10.0 or later
Microsoft SQL Server 2005 requires SQL Native Client or later
Microsoft SQL Server 2000 requires SQL Native Client or later (recommended) or SQL Server

The sqlcmd SQL Server utility must be installed on the RPS node to use the default (recommended) sqlcmd to execute SQL scripts. (For details, see step 6.e under "Configuring your RPS Node", in Chapter 2 of the JADE Synchronized Database Service (SDS) Administration Guide.)