Hi,
I recently upgraded our enterprise geodatabase in ArcGIS Pro after the sql database was upgraded.
All of the database had a status 11.0.0.3.0 except one and I am not sure if it's an issue
It says " This ArcGIS Pro 3.3.0 - 11.3.0.52636 geodatabase is up to date." Does anyone know why its different from the others ?
Solved! Go to Solution.
Once you restore the DB you have to re-sync the logins for the DB users, no OS users: https://support.esri.com/en-us/knowledge-base/re-synch-sql-server-logins-or-users-after-restoring-a-...
That should allow the data owners & SDE to connect without any issues. The reason the IT manager can access is probably due to their user being a SYSADMIN on the SQL instance.
I would possible have the IT admin undo what they did to get the DB users access to SDE.
Thanks George this is helping alot.
IT admin said the sysadmin dbo account is different from his so the issue might not be with the sync. Doesn't help troubleshooting when I don't have a good background in database.
You may want to work with Technical Support on this.......
Thank you for all your help.