Good morning, I'm currently working with a SQL Database created by a GIS contractor that preceded my time here in my new organization. Like in many local government organizations, me and my partners are trying to migrate decades of file folder-GIS (shapefiles, etc) to this SDE so we can provide access to multiple departments. I'm having 2 issues. which I believe are likely closely related:
1) When trying to provide permissions to our other department so they can curate their data and begin migrating it to a dataset on SDE, I received an error that I was not a 'sysadmin' or 'superuser'. How would I obtain this status? Is there a chance that the 'superuser' was the original database creator (the contractor no longer employed by the organization??..hopefully not).
2) Currently, the SDE access is operating system authenticated. When I attempt to create a new dataset (i.e. a planning-specific dataset for the Planning Department) it creates a dataset which is not visible to other uses in my organization and is given a prefix with my username (BJWALTERS seen below). It appears this dataset is conditional on my operating system authentication? I'm pretty confused on why this is happening, but my SDE knowledge isn't as deep as I wish it was. Feel free to review the screenshot below and any information/recommended reading on SDE databases/permissions would be greatly appreciated! Screenshot is attached below. Thanks!
What release of ArcGIS are you using? For both ArcGIS desktop and for the enterprise geodatabase? The fact that you're using the term "SDE" suggests that it's an older release, as we haven't used that term in the software since the 10.0 release.
FYI, the help documentation for enterprise geodatabases on SQL Server (formerly, "ArcSDE for SQL Server"),
Geodatabases in Microsoft SQL Server—Help | ArcGIS Desktop
> Is there a chance that the 'superuser' was the original database creator (the contractor no longer employed by the organization??..hopefully not).
This would likely be the case, unless the contractor created other geodatabase admin users.
You may want to reach out to esri Tech Support so they can help you "recover" your enterprise geodatabase.
Hope this helps,