Available with Standard or Advanced license.
When you enable a SQL Server Express instance to store geodatabases, a key is written to the Windows registry. This key indicates whether the database server is licensed under ArcGIS Desktop and ArcGIS Engine or ArcGIS Server Workgroup.
When you create a geodatabase on the database server or attach a geodatabase to the database server, the key is read from the registry and populates a field in a geodatabase system table.
Therefore, there are two different places that must be updated to update your license key: the registry and each geodatabase. You must run the Enable geodatabase storage on SQL Server Express portion of the Database Server setup wizard to update the license key in the registry. Then you must detach and reattach each existing geodatabase to update the license in the geodatabase if you need to update license keys in any of the following situations:
- You need to authorize your database server with a new ArcGIS Server Workgroup license key, such as when you move from ArcGIS Server Workgroup Basic to ArcGIS Server Workgroup Advanced.
- You are converting your database server licensed through ArcGIS Desktop or ArcGIS Engine to a database server licensed through ArcGIS Server Workgroup.
- You are converting your database server licensed through ArcGIS Server Workgroup to a database server licensed through ArcGIS Desktop or ArcGIS Engine.
- You were using an EDN or education site license but are moving to a production ArcGIS Server Workgroup license.
The following set of steps instruct you how to update the license key in the registry and each of the geodatabases:
- As a Windows administrator, log in to the computer on which the SQL Server Express instance is installed.
- Access the Database Server installation wizard. (This is usually an executable that you downloaded from My Esri.)
- If you are changing the licensing on your database server from ArcGIS Desktop or ArcGIS Engine to ArcGIS Server Workgroup or if you are updating your ArcGIS Server Workgroup license key, run the ArcGIS Server Workgroup executable.
- If you are changing your license from an ArcGIS Server Workgroup to an ArcGIS Desktop or ArcGIS Engine license, run the executable that comes with ArcGIS Desktop or ArcGIS Engine.
- When the installation options dialog box appears, click Database Servers.
- Click Next to proceed with the wizard.
- Uncheck Microsoft SQL Server Express Edition, leave Enable geodatabase storage on SQL Server Express checked, and click Next.
- From the drop-down menu, choose the name of the SQL Server Express instance for which you want to update the license key and click Next.
- If you are changing your license to an ArcGIS Desktop or ArcGIS Engine license, click Finish.
- If you are changing from an ArcGIS Desktop or ArcGIS Engine license to an ArcGIS Server Workgroup license or are updating the existing ArcGIS Server Workgroup license, you must authorize the ArcGIS Server Workgroup software by browsing to the ArcGIS Server Workgroup license key.
- To complete the authorization, click Finish.
- To update the license in a geodatabase, log in as a server administrator, start ArcMap, and open the Catalog window.
- Connect to the database server for which you just finished updating the registry.
- On the Contents tab, right-click the first geodatabase on the database server, click Administration, and click Detach.
- Click Yes to confirm that you want to detach the geodatabase. The geodatabase should disappear from the database server connection in the Catalog tree. Press F5 to refresh to ensure the geodatabase was detached.
The detach operation will fail if any other connections exist to the geodatabase.
- Right-click the database server and click Attach.
- On the Attach Geodatabase dialog box, browse to the .mdf file of the geodatabase you just detached.
- After you specify the file, click OK on the Browse dialog box.
- Click OK on the Attach Geodatabase dialog box.
- If there are additional geodatabases on the database server, repeat the preceding six steps to update the license keys in each of these geodatabases.