Why I get the message "maximum number of connections to instance exceeded"?

6431
7
07-11-2010 07:17 AM
Highlighted
Honored Contributor
Why I get the message "maximum number of connections to instance exceeded"

Please, see the attached image that shows my question
0 Kudos
7 Replies
Highlighted
Esri Esteemed Contributor
All ArcSDE instances have a limit on the number of concurrent users. If you reach the limit
you will get that message. If you have an Enterprise license, you can change CONNECTIONS
to a larger value (see the 'sdeconfig' command documentation), though you will eventully
start getting Windows errors instead of SE_CONNECTIONS_EXCEEDED if you set it too high.

Note: The non-interactive desktop heap OS connection limit is only on Windows server hosts,
and applies only to application server connections (not Direct Connect).

- V
0 Kudos
Highlighted
Occasional Contributor III
Just a tip: Some of the ArcSDE messages have been documented in the help topic ArcSDE error messages:

http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/ArcSDE_error_...

This may help you get a little more information on an error message you get back from ArcSDE.

Hope this helps,

Kim
0 Kudos
Highlighted
New Contributor
I was going to add that often times connections get hung.  If you haven't changed the kill time in the config file, I would make the change.  God luck.
0 Kudos
Highlighted
New Contributor III
Just wondering if there is a way to determine where the connections came from? Maybe a log file somewhere so we could determine what application/users were causing this error to be reported.

Thanks!
0 Kudos
Highlighted
New Contributor II
"sdemon -o info -I users" will tell where a connection is from (machine/OS). If you can see the SDE system table, the information is in SDE_process_information table.

The GDBT tool should also give you some info.
0 Kudos
Highlighted
Occasional Contributor
Try this command:

sdeconfig -o list -P CONNECTIONS -D <Database Name> -i <Service> -s <Server Name> -u <SDE Username> -p <SDE Password>

This will show you how many connections you have available now.  ArcSDE allows 48 by default.

Use this to change it:

sdeconfig -o alter -P CONNECTIONS=60 -D <Database Name> -i <Service> -s <Server Name> -u <SDE Username> -p <SDE Password>

the quantity can be of your choosing and make sure you have the administrative rights to alter the configuration.  See this link for more details.

http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/admincmdref.htm
0 Kudos
Highlighted
New Contributor
I am getting this same error with a new Workgroup Standard installation of 10.0 with sqlexpress. I did not have these issues on our 9.3 server.
Any ideas are appeciated.
0 Kudos