Creating Enterprise Geodatabase Issues

[DanaYoung]

Hi -

I have been trying to create my first Enterprise Geodatabase and it is not going smoothly. I keep getting an error with the Authorization file stating "parameter is missing or invalid" and I copied the keycode from where the information icon stated to get the keycode from.

I have a case open with Esri about this and we have gone through various troubleshooting, but still no luck. The case is still open and hopefully Esri IT can help, but in the meantime I thought I'd reach out to see if others have come across a similar issue.

Thanks for any insight to this issue.

[Scott_Tansley]

if you navigate to the keycodes file, and open it in a text editor, do you see one line that starts with arcsdeserver?  And what's it's expiry data/version?

[DanaYoung]

No I do not see that line at all nor a date.

[Scott_Tansley]

So basically you haven't got a license for the Enterprise Geodatabase and need to take it up with your local Esri (or Distributor) licensing team.  🙂

[DanaYoung]

haha, you think they would of caught that after talking with them a few different times about this. Thank you I will mention this to them.

[DanaYoung]

There was this line...

sdeworkgroup,109,ecp786258229

[Scott_Tansley]

ah, so you're trying to create a workgroup geodatabase in SQL Server Express, and not an Enterprise Geodatabase.  Sorry, subtle change in terminology but it means quite a lot.  

Types of geodatabases—ArcGIS Pro | Documentation

FAQ: Is it possible to create a workgroup geodatabase in ArcGIS Pro? (esri.com)

[DanaYoung]

My apologies, I'm still learning all this. It's new to me. Thanks again for you help!

[Scott_Tansley]

No need to apologise.  We all have to learn and I only know this because I've worked with ArcGIS Server since it's first release and the Enterprise Geodatabase before that.  Have a read of the doco, it's a shame we need to use ArcMap for managing the workgroup geodatabase though.  😞

[George_Thompson]

So that licensing is only for Workgroup geodatabases, which are based on SQL Server. Here is the docs for Workgroup (Database Servers): https://desktop.arcgis.com/en/arcmap/latest/manage-data/database-servers/overview-database-servers.h...

If you need to use an Enterprise RDBMS then you will need ArcGIS Server Basic license at the minimum.