I am fairly new to ArcGIS for Server and I am trying to read up on documentation about different database management systems and I cannot seem to find an answer on whether or not I can install ArcGIS for Server Advanced Enterprise on SQL Server Express? I'm trying to set up an Enterprise Geodatabase with the trial version of Server Advanced Enterprise. Any help would be much appreciated.
Jarom Hlebasko try to mark the responses which answered your questions as Helpful\Correct Answer, so that it may help other people in the future.
Thank you everyone for your help! I have learned a lot but have a long way to go!
It seems there are two sets of questions interleaved within this discussion.
There are three options for using SQL-Server Express:
Any way you roll it, Microsoft licensing restricts the SQL-Server application to a single CPU, a RAM limit, and a total storage limit. Using the non-Enterprise geodatabase options, Esri licensing also applies a 3 or 10 connection limit.
To answer the original question, yes, Microsoft SQL-Server Express is a supported RDBMS platform for an enterprise geodatabase (provided you conform to the system requirements).
It's also possible to use Esri tools to create new Express instances or geodatabase-enable databases within them, but only the enterprise geodatabase tools can create an enterprise geodatabase, and the Workgroup/Desktop tools create non-enterprise dtabases.
- V
Hi Jake,
Thanks for the info! So if I am understanding this correctly and based on the link you gave me, SQL Server Express is included with Desktop Standard & Advanced, Engine, and ArcGIS for Server Workgroup and ArcSDE for all other DBMSs is included with ArcGIS for Server? This being said, I do not have to purchase Standard SQL Server since it comes with ArcGIS for Server Advanced?
Thanks,
Jarom
Hi Jarom,
Take a look at the section 'How is ArcSDE technology included in ArcGIS' in the following link. Basically, with SQL Server Express you are limited to the amount of cores and RAM, database size, and the amount of users. With standard SQL Server, there is no limit for any of these.
What exactly is the main difference between Microsoft SQL Server express and just the standard SQL Server? I am leaning towards Amazon Web Services so it would be nice to know exactly what I need to get to effectively run the enterprise that I am wanting. Thank you for your help!
Basically you don't need SQL Server Express or rather any DBMS for installing ArcGIS Server. They are completely separate installations, with no links as such w.r.t installation.
Yes, the SQL Server Express instance can be used to create an sde enterprise geodatabase, as required.
Here are some links for reference. these are for 10.1. You can search for similar links for 10.2.x as well.
• A quick tour of setting up a geodatabase in SQL Server:
ArcGIS Help 10.1
• Creating a database and geodatabase in SQL Server:
• Enabling geodatabase functionality in an existing SQL Server database:
• Setting up a connection to SQL Server:
• Database connections in ArcGIS for Desktop:
Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
