English

Bug: Error: "No ArcSDE Server License Found" occurs when creating a new geodatabase with ArcSDE for SQL Server Express (Personal Edition) version 10.0

Description

When making a connection to the SQL Server Express instance in ArcCatalog and attempting to create a new geodatabase, the following error is returned:

"Error creating this geodatabase
No ArcSDE server license found."

This error occurs after installing ArcSDE for SQL Server Express (Personal Edition) that is included with the ArcGIS Desktop 10.0 installation media.

Cause

This is a known issue with the ArcGIS 10.0 installation of ArcSDE for SQL Server Express (Personal Edition). This error occurs when the software is installed from the setup link on the ArcGIS Desktop installation screen (ESRI.exe application), or by manually executing setup.exe in the ArcSDE_Personal folder.

Workaround

Option 1

Esri recommends using this repair utility.

1. Download and run NIM058807_Repair.
2. When this utility opens, select the appropriate instance of SQL Server Express and click OK.

A valid license key that correctly authorizes the installation is written to the registry. It is now possible to create a new geodatabase using the Database Server connection in ArcCatalog.

Option 2

Instead of installing from the ESRI.exe application or setup.exe in the ArcSDE_Personal folder, install using the ArcSDESetupSqlExpressPersonal.exe in either the 32-bit or 64-bit folder, depending on whether a 32-bit or 64-bit operating system is being used.

  1. Determine if a 32-bit or 64-bit machine is being used and open the appropriate folder under ArcSDE_Personal.
    [O-Image] ArcSDEPersonal
  2. Find and run the ArcSDESetupSqlExpressPersonal.exe.
    [O-Image] ArcSDEPersonal1
  3. When the installation wizard opens, uncheck Microsoft SQL Server Express Edition if SQL Server is already installed.

    Leave the option 'Enable geodatabase storage on SQL Server Express' checked and click Next.
    [O-Image] ArcSDEPersonal2
  4. Select the existing SQL Server Express instance from the drop-down menu and enter the Windows Login, if required. Click Next.
    [O-Image] ArcSDEPersonal3
  5. Click Finish.

    This process correctly authorizes the installation by writing a valid license key to the registry. It is now possible to create a new geodatabase using the Database Server connection in ArcCatalog.

Related Information