SDE Upgrade to 10.5: error (-96)

4595
9
Jump to solution
12-19-2016 07:45 AM
MarkusSchenardi
Occasional Contributor

Trying to update an SDE Database (SQL Server) from 10.4.1 to 10.5.

Error Message: 

Could not update server tables and stored procedures. (sde_branches : Error (-96)   DBMS error code: 0)

Any suggestions how to fix these?

Markus Schenardi
Laixo AG - Zürich - Switzerland
Member of the Esri Partner Network
1 Solution

Accepted Solutions
MarkusSchenardi
Occasional Contributor

The Solution was:

- add the db_owner permission to the sde user and use the sde user to run the update tool (and not the schema owner).

- do NOT add the sysadmin role to the sde user, otherwise you get another error: ERROR installing/upgrading ArcSDE, Error = -549
(Error: Geodatabase upgrade in SQL Server fails with error code -549 in the log )

Markus Schenardi
Laixo AG - Zürich - Switzerland
Member of the Esri Partner Network

View solution in original post

9 Replies
AdamZiegler1
Esri Contributor

Hi Markus - I ran into the same issue. The only way I found around it was to add the necessary privileges to the SDE user and run the upgrade with a connection as SDE.

Adam Z

0 Kudos
RhiannMackenzie
New Contributor II

Hi Adam, 

Is this a known bug? What necessary privileges did you have to give to SDE? Just the ones documented here?

Privileges for geodatabases in SQL Server—Help | ArcGIS Desktop 

0 Kudos
AdamZiegler1
Esri Contributor

Hi Rhiann - My SDE user had those privileges from creation, but I did need to add DB_OWNER to the SDE user. This was removed post-upgrade.

Adam Z

MarkusSchenardi
Occasional Contributor

The Solution was:

- add the db_owner permission to the sde user and use the sde user to run the update tool (and not the schema owner).

- do NOT add the sysadmin role to the sde user, otherwise you get another error: ERROR installing/upgrading ArcSDE, Error = -549
(Error: Geodatabase upgrade in SQL Server fails with error code -549 in the log )

Markus Schenardi
Laixo AG - Zürich - Switzerland
Member of the Esri Partner Network
Asrujit_SenGupta
MVP Regular Contributor

This worked, however my assumption was that the upgrade should always work when connected as 'sa' or any sysadmin login. Which didn't happen in this instance, not sure why.

Christopher_TNiven
New Contributor

Hi Markus-

Thank you.

Perhaps you would include a screen shot depicting the difference between assigning the permission vs. adding the sysadmin role to the sde user? Just something to clarify the process for those who might not be directly familiar with the process in MSSQL or PostgeSQL, etc.

0 Kudos
MarkusSchenardi
Occasional Contributor

Do not set the sysadmin permissionAssign the db_owner Database Role to the sde user

Markus Schenardi
Laixo AG - Zürich - Switzerland
Member of the Esri Partner Network
PhilippeDerynck
New Contributor II

Hi Markus,

We have the same error when updating a SDE Database (SQL Server) from 10.3.1 to 10.5. or 10.4.1 to 10.5

If I use the settings you provided, I get the message that: User does not have required privileges to upgrade. [Operation Failed]

Any ideas?

0 Kudos
Lake_Worth_BeachAdmin
Regular Contributor

I am receiving the following error when attempting to upgrade the SDE from 10.4.1 to 10.5.1

Could not update server tables and stored procedures. ( Error (-9)
  DBMS error code: 0
42000:[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot execute as the database principal because the principal "public" does not exist, this type of principal cannot be impersonated, or you do not have permission.

SDE user is db_owner and there is a public role which he is apart of

0 Kudos