Is it possible to enable an enterprise geodatabase within a trial version of ArcGIS Desktop 10.5?
I can't find a way to access/create an Authorization File for use in the "Enable Enterprise Geodatabase" tool.
you need to have ArcGIS for Server license to enable this feature. You need to ask your Esri Rep. for ArcGIS for Server trial.
I am also having a problem enabling an enterprise geodatabase (although my ArcGIS Desktop and ArcGIS for Server licenses are not trial license). When I try to run the tool, the log shows that it goes through a bunch of database steps successfully, and then it says:
[Thu May 18 09:59:58 2017] Error creating GDB_Tables_Last_Modified table... [Thu May 18 09:59:58 2017] ERROR Creating Geodatabase tables, Error = -511,EXT_Error = 0,EXT_ERROR1 = Database user name and current user schema do not match.,EXT_ERROR2 = ,
The database folks assure me that the database is setup per the instructions here: http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/setup-geodatabase-sqlserver.htm#ESRI_SECTION1_0CB5A7EBA7EB4F69AA7180F0FA84779E
Can you tell what the problem might be from this error?
Diane Snediker I would recommend creating a new quesiton for your post in the Geodatabase group.
Based on the error message there appears to be a mismatch of the DB name and schema in SQL Server. Does the username and schema match in SQL Server? i.e. User Name = SDE and Schema = SDE?
-Are you creating a DBO or SDE enabled geodatabase?
***Update: You may also want to review this link, if using SDE: How To: Create an SDE schema geodatabase using the Enable Enterprise Geodatabase geoprocessing tool in SQL Server
OK, I will move it and you can answer again there, I guess?
Is this just the case with the trial version? If I were to purchaser ArcGIS Desktop Standard, would I be able to enable an enterprise geodatabase? The "Enable Enterprise Geodatabase" tool indicates that only ArcGIS Desktop Standard, and does not indicate ArcGIS for Server is required.
Thanks again for your help and quick response.
If I were to purchaser ArcGIS Desktop Standard, would I be able to enable an enterprise geodatabase?
Not really, you have to have ArcGIS Server license file. With ArcGIS Desktop Standard you can only enable Enterprise Geodaabase for personal use (1 editor, 2 viewers) that works on top of MS SQL server.
The "Enable Enterprise Geodatabase" tool indicates that only ArcGIS Desktop Standard, and does not indicate ArcGIS for Server is required
Right, but this refers to the tool licnsing itself. To administer ArcGIS for Server, you need to have at least ArcGIS Desktop Standard.
Is this what I need to do in order to create a geodatabase in MS SQL Server Express using only ArcGIS Desktop Standard without ArcGIS for Server? (I understand the limitations):
Create a desktop or workgroup geodatabase—ArcGIS Help | ArcGIS Desktop
Indeed, after having installed database server, follow the documentation you mentioned above.
Thanks Adam, but I'm getting thwarted at each turn. If I following instructions at Create a desktop or workgroup geodatabase—ArcGIS Help | ArcGIS Desktop, I get the following error:
"Error creating this geodatabase. The application is not licensed to perform this operation."
Not sure where to go from here - if it is the Trial version permissions and installation, or issues with my MS SQL Server Express.
Thanks for your help,
Can you at least connect to your MS SQL Server instance using ArcMap and SQL Server Management Studio? Have you installed SQL Server provided by Esri or you have downloaded it form MS site? What version of ArcGIS are you running?
Yes, I can connect to the MS SQL Server Express instance through ArcMap (and add existing spatial data) and SQL Sever Management Studio.
I downloaded Microsoft SQL Server 2016 (64-bit) from Microsoft site: since I'm using a Trial of ArcGIS Desktop, there are no download options on MyEsri (so I can't download MS SQL Server Express from Esri).
My main motivation for downloading the trial version is to assess the capabilities of ArcGIS Desktop (Standard) in relation to creating and using geodatabases SQL Server Express.
Thanks for your interest and help.
Please check out the description: "Use the SQL Server Express installation file provided with ArcGIS Desktop, ArcGIS Engine, or ArcGIS Server Workgroup to install SQL Server Express and enable it to store geodatabases." on Database servers—Help | ArcGIS Desktop.
It seems you need to contact your Esri Rep to get the install files.
Hope this helps,
Thanks Adam - I'm discussing with Esri Rep now.
Thanks again - very helpful.
Retrieving data ...