Select to view content in your preferred language

ArcGIS Pro 3.1.4 cannot enable geodatabase in SQL Server

326
2
Jump to solution
04-03-2024 02:21 PM
GrantSmith122
New Contributor III

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).

0 Kudos
1 Solution

Accepted Solutions
JoseG_Esri
New Contributor II

Can you try revoking sysadmn from sde? (SQL Server sees that as dbo)

To revoke it:

ALTER SERVER ROLE sysadmin DROP  MEMBER sde;

 

View solution in original post

2 Replies
JoseG_Esri
New Contributor II

Can you try revoking sysadmn from sde? (SQL Server sees that as dbo)

To revoke it:

ALTER SERVER ROLE sysadmin DROP  MEMBER sde;

 

GrantSmith122
New Contributor III

That was it! Thank you so much

0 Kudos