Error:  Geodatabase upgrade in SQL Server fails with error code -549 in the log

【相关信息】
Article ID: 40606
Software:
ArcSDE 10.1
Platforms:
Windows Server 2003, Server 2008, Windows 7

【错误信息】
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\Esri\Desktop10.1\GDBUpgrade.log
C:\Users\sean4788\AppData\Local\Temp\2\sde_setup.logUnpaused the database.
Failed to execute (UpgradeGDB)."
The following messages occur in the sde_setup.log:


"[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.