I am having a problem enabling an enterprise geodatabase. When I try to run the tool, the log shows that it goes through a bunch of database steps successfully, and then it says:
[Thu May 18 09:59:58 2017] Error creating GDB_Tables_Last_Modified table... [Thu May 18 09:59:58 2017] ERROR Creating Geodatabase tables, Error = -511,EXT_Error = 0,EXT_ERROR1 = Database user name and current user schema do not match.,EXT_ERROR2 = ,
The database folks assure me that the database is setup per the instructions here: http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/setup-geodatabase-sqlserver.htm#ESRI_SECTION1_0CB5A7EBA7EB4F69AA7180F0FA84779E
Can you tell what the problem might be from this error?
How do I check what the schema name is? the user name is definitely sde.
There is a huge list. I have confirmed the four you mentioned are in the list.
OK, thank you. I had reached out to my ESRI rep last week and not heard back.
I would recommend opening a technical support case to have an analyst look at this in more detail. It would also be good to have the DBA available for calls.
In SSMS, right click on the database -> properties -> permissions -> click on sde user -> effective and please confirm which permissions are granted.
Yes, they are both sde
Both the username and default schema are sde. And those other options are both set to TRUE. I am told by the SQL server folks that sde is the administrator so it has all those privileges.
Hello,
1. Make sure set SQL Server database options READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION to ON. You can check the two options by right clicking on the database > Properties > Options.
2.You can check the schema of the user by following steps:
In SSMS, Security --> Logins --> Right click on the user --> Properties --> User Mapping --> make user that user name and default schema match.
3. Make sure user have, at a minimum, the following privileges: CREATE FUNCTION, CREATE PROCEDURE, CREATE TABLE, and CREATE VIEW.---------------------------------------------------------------------- Set up an enterprise geodatabase in SQL Serverhttps://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/setup-geodatabase-sqlserver.htm ----------------------------------------------------------------------
Based on the error message there appears to be a mismatch of the DB name and schema in SQL Server. Does the username and schema match in SQL Server? i.e. User Name = SDE and Schema = SDE?
You may also want to review this link: How To: Create an SDE schema geodatabase using the Enable Enterprise Geodatabase geoprocessing tool in SQL Server It shows you where to check if the schema/username matches - look at Step 2.
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
