topic Re: SDE Upgrade to 10.5: error (-96) in ArcGIS Enterprise Questions

SDE Upgrade to 10.5: error (-96)

MarkusSchenardi — Mon, 19 Dec 2016 15:45:25 GMT

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?

Re: SDE Upgrade to 10.5: error (-96)

AdamZiegler1 — Mon, 19 Dec 2016 17:09:15 GMT

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

Re: SDE Upgrade to 10.5: error (-96)

RhiannMackenzie — Mon, 19 Dec 2016 20:47:31 GMT

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

Re: SDE Upgrade to 10.5: error (-96)

AdamZiegler1 — Mon, 19 Dec 2016 20:55:59 GMT

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

Re: SDE Upgrade to 10.5: error (-96)

MarkusSchenardi — Wed, 21 Dec 2016 08:31:09 GMT

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 )

Re: SDE Upgrade to 10.5: error (-96)

Asrujit_SenGupta — Mon, 20 Feb 2017 06:05:09 GMT

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.

Re: SDE Upgrade to 10.5: error (-96)

Christopher_TNiven — Tue, 07 Mar 2017 21:21:54 GMT

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.

Re: SDE Upgrade to 10.5: error (-96)

MarkusSchenardi — Wed, 08 Mar 2017 07:03:20 GMT

Re: SDE Upgrade to 10.5: error (-96)

PhilippeDerynck — Thu, 16 Mar 2017 14:03:15 GMT

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?

Re: SDE Upgrade to 10.5: error (-96)

Lake_Worth_BeachAdmin — Wed, 14 Feb 2018 11:43:06 GMT

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