SDE Upgrade to 10.5: error (-96)

[MarkusSchenardi]

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?

[AdamZiegler1]

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

[RhiannMackenzie]

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 

[AdamZiegler1]

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 · Accepted solution]

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 )

[Asrujit_SenGupta]

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]

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.

[MarkusSchenardi]

[PhilippeDerynck]

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?

[Lake_Worth_BeachAdmin]

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