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.
