Failed to compress the database. Operation Failed [sde.default]

Last Published: April 25, 2020

Error Message

The following error occurs when the 'sde' user compress using ArcCatalog tools."Failed to compress the database
Operation Failed [sde.default]"


If the 'sde' user does not have 'View Server State' permission at the instance level in SQL Server 2005, compressing with ArcCatalog will fail.

Compressing with 'sdeversion -o' works successfully.

Solution or Workaround

  1. On the machine where SQL Server 2005 is installed, navigate to Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
  2. Highlight and right-click the instance and click Properties.
  3. In the Server Properties window:
    A. Select 'Permissions'.
    B. Highlight the 'sde' user. Verify the user has 'View Server State' permission available.
    C. Click the check box under 'Grant' for the 'View Server State' permission.

Article ID:000008907

  • Legacy Products
  • ArcMap 9 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic