HOW TO

Update an expired enterprise geodatabase license via SQL Server Management Studio

Last Published: October 11, 2023

Summary

The ArcGIS Server term license is subject to expiration and must be updated manually on the machine hosting ArcGIS Server. When an ArcGIS Server term license expires and ArcGIS Server has an enterprise geodatabase connection registered, the license for the related enterprise geodatabase must be replaced and updated along with the renewal of the server's license. This article demonstrates how to update the expired enterprise geodatabase license via SQL Server Management Studio.

Procedure

Note:
If the ArcGIS Server license is up-to-date, proceed to Step 2.
  1. On the machine hosting ArcGIS Server, log in to My Esri to obtain the new license file for the new term date and authorize the new ArcGIS Server term license. Refer to Steps 1 to 3 of How to: Replace expired ArcGIS Server and Enterprise geodatabase licenses to do so.
Note:
If ArcGIS Server is federated with ArcGIS Data Store, refer to How To: Update the ArcGIS Data Store license via command utilities for steps to update the ArcGIS Data Store license.
  1. Make a copy of the keycodes file generated on the ArcGIS Server machine to the machine hosting SQL Server Management Studio and rename the duplicate file with a .ecp file extension. The following path is the default keycodes file directory on an ArcGIS Server machine.
Warning:   
Do not rename the original keycodes file as this may disrupt the functionality of the ArcGIS Enterprise deployment.
C:\Program Files\ESRI\License<VersionNumber>\sysgen
  1. Open the duplicate file using a text editor on the SQL Server Management Studio machine.
  2. Search for and copy the first six arcsdeserver license information in the text editor window. The arcsdeserver license information is displayed in the following format.
arcsdeserver,<ProductVersion>,<LicenseNumber>,<ExpirationDate>,MachineInfo>,<DetailsNumber>
  1. Open and log in to SQL Server Management Studio using a sa account.
  2. In the Object Explorer pane, expand and navigate to the database with the expired license > Tables.
The Tables node of the desired database
  1. Right-click the server configuration file, and click the Select Top 1000 Rows option from the drop-down menu.
Note:
The server configuration file on the machine is named as either sde.SDE_server_config or dbo.SDE_server_config.
The Select Top 1000 Rows option
  1. On the Results tab of the Query Editor window, scroll and search for AUTH_KEY in the table to verify the details and expiration date of the current license.
The AUTH_KEY row on the Results tab
  1. In the Query Editor window, press Enter twice and paste the following script with the license information copied from Step 4.
UPDATE <ServerConfigurationFileName>
SET char_prop_value = '<arcsdeserverLicenseInformation>'
WHERE prop_name = 'AUTH_KEY'
The script used in the Query Editor window
  1. Highlight the command in the Query Editor window and click Execute.
The Execute option in the toolbar
  1. Repeat Steps 6 to 8 to verify that the Auth_Key row is updated with the new license information.
  2. To ensure the SQL database is working as intended after updating the license, log in to ArcGIS Server Manager on a web browser.
  3. In ArcGIS Server Manager, navigate to Site > Data Store and check the SQL database checkbox.
  4. Click Validate.
Note:
Alternatively, if the SQL database is registered in ArcGIS Pro, click and expand the nodes of the database in the Catalog pane to ensure the services are available and working as intended.

Article ID: 000031299

Software:
  • ArcGIS Server
  • ArcGIS Enterprise 10 9 x
  • ArcGIS Enterprise 11 0
  • ArcGIS Enterprise 11 1

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options