Is This Content Helpful?
We're glad to know this article was helpful.
When upgrading an sde schema geodatabase in SQL Server, it fails with the following error message in the geoprocessing tool:
"Updating server tables and stored procedures.
Could not update server tables and stored procedures.
Refer to upgrade logfiles for more details:
C:\Users\sean4788\AppData\Local\Temp\2\sde_setup.logUnpaused the database.
Failed to execute (UpgradeGDB)."
"[Tue Sep xxxxx]
DB_instance_open() against SQL Server using OLEDB driver.
[Tue Sep xxxxx] ERROR installing/upgrading ArcSDE, Error = -549
Updating server tables and stored procedures."
Adding the sde user to the SQL Server sysadmin fixed server role is not supported.
Which login and privileges are used to upgrade an sde schema geodatabase depends on the geodatabase model used: single- or multiple-database.
See the link in the Related Information section for more information about upgrading user privileges.