Problem enabling an enterprise GDB

[DianeSnediker]

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

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.

[DianeSnediker]

I had the DB folks do this. Now when I try to run Enable Geodatabase, I get this:

[Tue Jun 13 10:25:09 2017] Error creating VERSION table. (-51)
[Tue Jun 13 10:25:09 2017] DBMS error code: 2760
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The specified schema name "sde" either does not exist or you do not have permission to use it.

[Tue Jun 13 10:25:09 2017] SDE schema object install not completed.
[Tue Jun 13 10:25:09 2017] ERROR installing/upgrading ArcSDE, Error = -51

The default schema for user sde is still listed as sde.

[DianeSnediker]

Nevermind. The DB folks got back to me and seem to have fixed it:

"I've changed the owner of the sde schema to be user sde, instead of dbo"

[George_Thompson]

That would cause a lot of problems.

[George_Thompson]

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.

[DianeSnediker]

OK, thank you. I had reached out to my ESRI rep last week and not heard back.