topic Re: Maximum Number of Instances in ArcGIS Enterprise Questions

Maximum Number of Instances

WalterDziuba — Tue, 04 Feb 2014 16:41:38 GMT

Afternoon,

I've loaded several new features into a SQLExpress SDE database. I was successful in registering the folder that the connection to my database resides in, but I keep getting the error below when I attempt to register the database inself. I browse to the folder and select my connection *.sde and attempt to import it, but it always fails.

The connection property set was missing a required property or the property value was unrecognized. Maximum number of connections to instance exceeded.

I attempted to view the services running on my pc, through the Windows Service Manager, but there are no instances of ArcSDE running? As well, I checked the value set inside my dbo.SDE_server_config and the connections = 64.

How do I set a higher number of usable instances? Why is not showing up in the Windows Service Manager?

How do I find out how many / and who is using up all my instances? I'm the only one working on this machine and both my ArcGIS server and SQL Express installation is local to my machine.

Walter

Re: Maximum Number of Instances

George_Thompson — Wed, 05 Feb 2014 00:05:21 GMT

Walter,

Using SQL Server Express you are limited to the number of connections that are allowed based on your license level (Workgroup vs. Personal). Even though the server_config table show that 64 connections are allowed, it is limited by SQL Server Express. This is because SQL Server Express is a free product offered by Microsoft (Esri just packages it up to make it easy to find and use). There are also other limitations that SQL Server Express has, for example only using 1GB of RAM and 1 CPU core
(Under the section - How is ArcSDE technology included in ArcGIS?: http://resources.arcgis.com/en/help/main/10.2/index.html#//003n00000007000000)

Only ArcGIS products (ArcMap, ArcCatalog, ArcGIS for Server, etc..) count as connections to the geodatabase.

To see more information on Multiuser Geodatabases visit here: http://www.esri.com/software/arcgis/geodatabase/multi-user-geodatabase

If you need more than 10 concurrent connections to the geodatabase, I would recommend looking into to using an Enterprise version of a RBDMS system that is supported with a ArcGIS for Server Enterprise license (Basic, Standard or Advanced). Look under the Relational Database Management Systems tab under the System Requirements page for supported RDBMS versions.

ArcGIS for Server Functionality: http://www.esri.com/software/arcgis/arcgisserver/features/functionality-table

Hope this helps....

George

Re: Maximum Number of Instances

NidhinKarthikeyan — Wed, 05 Feb 2014 06:40:28 GMT

Use sdeconfig -o alter command to change the value of the CONNECTIONS parameter. Take a look at this techincal article:
http://support.esri.com/es/knowledgebase/techarticles/detail/23763

Re: Maximum Number of Instances

WalterDziuba — Wed, 05 Feb 2014 11:32:29 GMT

Nidhin,

Thank you for your reply and link to a technical support article.

I will attempt to adjust the number of SQL Express SDE instances and will get back to you if I have any more
technical difficulties.

Thanks....Walter