I am in the process of migrating/upgrading our single server Enterprise 10.9.1 on Windows Server 2016 software to a multi-machine Enterprise 11.5 installed on Windows Server 2025. While doing so, I'd like to update our SDE connections to 'best practices' (as I understand them - it's all a bit daunting).  We have SQL Server 16 on a Windows Server 2022 Datacenter. There are 3 full-time GIS users who access the EGDBs regularly. All of us need the ability to read, write, and publish services from the EGDBs. Currently, we all access the 10.9.1 EGDBs as SDEADMIN. My thought process is that I should create new EGDBs at the 11.5 version using the SDEADMIN and then run the Create Database User tool to add the 3 GIS users. Then my GIS Team can connect to the new EGDBs as individuals instead of sharing the SDEADMIN account. But, that isn't working for me...  😞 I've created an EGDB, created the Database User, and can connect to the EGDB using OS authentication. But then my users can't add or edit items in the EGDB. I poked around enough to figure out how to add each user to a feature class and give them privileges, but I've got nearly 500 feature classes to migrate to the new EGDB. No one has the time or patience to edit those privileges on each FC every time one is added, let alone to all of them at once. Is there a way to set permissions/privileges at the EGDB level?  Does anyone have a handy flow chart of how the 'best practices' work together? Or an explanatory video? I've got so many tabs open right now I'm completely lost. It took me three hours to find this group! Any help would be *greatly* appreciated! ... View more

ArcGIS Desktop (ArcMap) 10.8.2 (the latest and last version) will switch to 'Mature' support in March 2024. That means no more software updates or patches. ArcMap PLC - https://support.esri.com/en-us/products/arcmap/life-cycle   ... View more