Replacing the SQL Server Native Client (SQLNCLI or SQLNCLI11)
The SQL Server Native Client (SQLNCLI or SQLNCLI11) provider has been replaced with the Microsoft OLE DB 19 for SQL Server (MSOLEDBSQL19). It supports the SQL Server 2022 and provides extended security.
Upgrading to the newest Omada Identity version requires installing the Microsoft OLE DB Driver 19 for SQL Server (MSOLEDBSQL19), and provisioning a verifiable certificate on SQL Server.
For more details, go to the Server software requirements
Additionally, manual update of data connections containing the provider with the MSOLEDBSQL19 value is required. Make sure that the Data source matches the name on the SQL Server certificate.
Contrary to the provider in the Omada ODW ConnectionString.dtsConfig, which is automatically updated during installation, the Data Source requires manual update.
The MSOLEDBSQL19 provider is automatically utilized by systems with SQL connectivity, unless the provider is directly configured in the OLE DB Provider field in the Connection details section or specified in connection string.
Onboarded system with the legacy provider remain operational, however it is recommended to update the provider to the MSOLEDBSQL19 provider.