I want to enable SDE on the SQL Server DB but I get error with 'Could not create geodatabase tables and stored procedures'. I tried with ArcGIS Pro (v2.4), ArcCatalog (v 10.4.1), SQL Server 2014.
I followed through this support page: Error: Could not create geodatabase tables and stored procedures. Failed to execute (EnableEnterpriseGeodatabase) but no resolution. I get the similar (same) error message shown in that page.
It can connect to other DB on the same server without problem.