Maximum Number of Instances

[WalterDziuba]

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

[George_Thompson]

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

[NidhinKarthikeyan]

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

[WalterDziuba]

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