I have created an external list using an external content type reading from a database server on our network that is not on the same machine as our SharePoint database server. I am also sysadmin on the database server and web application admin on the SharePoint web application if that really matters.
I am trying to create alerts on the external list, but I am unsuccessful. I have tried the following steps:
Clicking "Set alert on this list" which returns the error "Alerts are not enabled on this list. Please contact the site administrator to ensure the backend supports alerts and the feature 'External System Events' is enabled on this site and try again."
Enabling 'External System Events' and retrying step 1, but receive the same error
Enabling 'ExternalSubscriptions' via PowerShell on the SharePoint server even though it is the same as 'External System Events', then I retry step 1 and receive the error again
I know you could not create alerts previously on external lists in SharePoint 2010, but you can create alerts on external lists in SharePoint 2013 (according to Microsoft).