Wednesday, 1 July 2026

ArcGIS Pro – Deleting an Enterprise Geodatabase User in SQL Server

1. It is essential to first delete all tables associated with the user via ArcGIS Pro.

2. Only then should you delete the user in SQL Server.

If you delete the user directly in SQL Server, certain data entries may remain in the enterprise system tables; these entries will appear in the Catalog but cannot be deleted from there.


ArcGIS Pro does not provide a tool for deleting enterprise users in SQL Server. ESRI documentation also offers no instructions on the correct procedure for deleting a user in SQL Server. You may find advice online suggesting that the user be deleted directly in SQL Server—but doing so can lead to the problems mentioned above.

Friday, 19 June 2026

ArcGIS Pro – Clone a virtual Python environment for offline machines

In ArcGIS Pro you need to create a new virtual Python environment in order to install additional Python packages. How can you set up that virtual environment on a machine that has no Internet access?

The first surprise is that creating a new virtual environment requires Internet access at all — I had assumed the existing Python environment would simply be copied locally. When creating a new virtual environment, ArcGIS Pro attempts to download Python packages, presumably to install the most recent available versions.

The simplest solution seems to be: create the new virtual environment on a machine that has Internet access, install all additional packages you need there, then copy that environment folder to the offline machine.

Prerequisite: ArcGIS Pro must be the same version on both machines — in other words, the Python runtime must match. I don't know how exact that version match must be.

 Steps:

1) Create a new Python environment in ArcGIS Pro.

2) Install the additional packages you require.

3) The newly created environment is placed in the user's folder:

C:\Users\<username>\AppData\Local\ESRI\conda\envs

Zip the subfolder that corresponds to the environment you want, copy the zip file to the target (offline) machine, and extract it into the same folder there.


 

See also: Solved: How to clone the ArcGIS Pro 3 Python environment? - Esri Community