Attribute Rules and editing via Feature service work with Oracle but not with SQL Server

[HennieDeurhof]

Hi,

I have a project that relies heavily on attribute rules. Recently we moved from ArcGIS Enterprise on premises to ArcGIS Enterprise on Azure. On premises we used an Oracle Enterprise database, on Azure we are using a SQL Server Enterprise database.

With Oracle, everything worked smoothly. Now with SQL Server however, attribute rules generate the following error message:

I have checked everything and can not find any differences between the old and the new setup. Everything is as it should be, but it refuses to work.

I have no clue what is prohibiting the attribute rules from working properly. Is it a syntax issue? Is it a versioning issue?

An example of an attribute rule:

Does anyone have an idea what can be causing this failure?