topic Re: Problem enabling an enterprise GDB in Geodatabase Questions

Problem enabling an enterprise GDB

DianeSnediker — Mon, 12 Jun 2017 14:22:13 GMT

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.

Re: Problem enabling an enterprise GDB

George_Thompson — Mon, 12 Jun 2017 14:24:32 GMT

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.

Re: Problem enabling an enterprise GDB

ManviLather1 — Mon, 12 Jun 2017 14:29:45 GMT

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 Server
https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/setup-geodatabase-sqlserver.htm
----------------------------------------------------------------------

Re: Problem enabling an enterprise GDB

DianeSnediker — Mon, 12 Jun 2017 14:36:06 GMT

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.

Re: Problem enabling an enterprise GDB

DianeSnediker — Mon, 12 Jun 2017 14:36:19 GMT

Yes, they are both sde

Re: Problem enabling an enterprise GDB

ManviLather1 — Mon, 12 Jun 2017 14:42:29 GMT

In SSMS, right click on the database -> properties -> permissions -> click on sde user -> effective and please confirm which permissions are granted.

Re: Problem enabling an enterprise GDB

George_Thompson — Mon, 12 Jun 2017 14:45:08 GMT

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.

Re: Problem enabling an enterprise GDB

DianeSnediker — Mon, 12 Jun 2017 14:46:12 GMT

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

Re: Problem enabling an enterprise GDB

DianeSnediker — Mon, 12 Jun 2017 14:50:00 GMT

There is a huge list. I have confirmed the four you mentioned are in the list.

Re: Problem enabling an enterprise GDB

George_Thompson — Mon, 12 Jun 2017 14:51:28 GMT

Make sure that they did not give "SYSADMIN" to the SDE user.

Re: Problem enabling an enterprise GDB

DianeSnediker — Mon, 12 Jun 2017 14:57:37 GMT

I don't see it on the list. I think I misspoke before, I think sde is the db owner, not "administrator"

Re: Problem enabling an enterprise GDB

ManviLather1 — Mon, 12 Jun 2017 14:59:25 GMT

Please confirm if "sysadmin" fixed server role or db_owner database role is granted to the sde user or not. If yes, then revoke these role and grant CREATE FUNCTION, CREATE PROCEDURE, CREATE TABLE, and CREATE VIEW to the sde user.

Re: Problem enabling an enterprise GDB

DianeSnediker — Tue, 13 Jun 2017 15:06:05 GMT

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.

Re: Problem enabling an enterprise GDB

DianeSnediker — Tue, 13 Jun 2017 15:13:28 GMT

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"

Re: Problem enabling an enterprise GDB

George_Thompson — Tue, 13 Jun 2017 15:15:38 GMT

That would cause a lot of problems.