Hello, I'm having some trouble enabling a geodatabase in SQL Server via Pro 3.1.4. The error message I receive when enabling is:
--------------
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Successfully enabled database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT.
[To create an SDE schema geodatabase, revoke database owner from the SDE login. [Success]]
See the setup log in the following location for additional error information:
C:\[path]\sde_setup.log
Could not create geodatabase tables and stored procedures.
Failed to execute (EnableEnterpriseGeodatabase).
-------------
I have confirmed that the sde user in SQL server is not the "db_owner" of the database in question and made sure that all the necessary permissions were given to the sde user within the database (CREATE FUNCTION, CREATE PROCEDURE, CREATE TABLE, and CREATE VIEW enabled, etc.)
When I check the log file referenced in the error message, this is what is written:
-------------
[15:10:52.208] In SE_arcsde_schema_setupEx() ...
[15:10:52.208] Calling sdemssqlsrvr.dll::DB_arcsde_setup() ...
[15:10:52.234] ERROR installing/upgrading ArcSDE, Error = -549
-----------
I can't find any information on the -549 error. Has anyone seen this error before? The sde user is also a sysadmin, and the SQL Server version is 16.0.4095.4 (built on windows server 2022).
