topic number of session exceeded in Data Management Questions

number of session exceeded

yousradaoudi — Fri, 04 Apr 2014 11:26:30 GMT

hello
i'm using arcgis desktop 10.2 and sql server 2008 express in the same machine just for test when more than 3 machine try to connect to my Geodabase (sql server ) they have this message :number of session exceeded
can someone know why i have this problem knowing thati have arcgis advanced and sql server 2008 express the both accepte many connection at a time

thanks

Re: number of session exceeded

WilliamCraft — Fri, 04 Apr 2014 11:34:31 GMT

hello
i'm using arcgis desktop 10.2 and sql server 2008 express in the same machine just for test when more than 3 machine try to connect to my Geodabase (sql server ) they have this message :number of session exceeded
can someone know why i have this problem knowing thati have arcgis advanced and sql server 2008 express the both accepte many connection at a time

thanks

ArcGIS for Server Workgroup is what you are likely licensed for since you mentioned the use of SQL Server 2008 Express. This level of ArcGIS for Server only allows for 10 concurrent geodatabase connections. Do you have any published GIS services which reference data in your SQL Server Express instance? That might explain by three ArcGIS for Desktop connections push your connection limit over the edge. Otherwise, are there other ArcGIS for Desktop sessions open on any other machines that could be contributing to the 10-connection max?

Re: number of session exceeded

VinceAngelo — Fri, 04 Apr 2014 11:36:03 GMT

Did you install an Enterprise geodatabase? Express has a limit on connections, as well.
Is this a database error (-51) or the SE_CONNECTIONS_EXCEEDED ArcSDE error (-7)?

- V

Re: number of session exceeded

yousradaoudi — Fri, 04 Apr 2014 11:49:41 GMT

thanks for responding , i'm just triyng to use a free sde geodatabase so i use sql server express ( i don't know why u're talking about arcgis server) i'm just using arcgis desktop 10.2 and sql server experss on my machine so that we can work in collaboration (many people at the same geodatabase) and when we have more than 3 person connected i have this error

Re: number of session exceeded

WilliamCraft — Fri, 04 Apr 2014 11:58:12 GMT

FYI... ArcSDE (including ArcSDE for SQL Server Express) is a component of ArcGIS for Server. At ArcGIS 9.2, Esri stopped selling ArcSDE as a stand-alone product. I believe the authorization ECP number provided with your ArcGIS for Server licensing is the same ECP number used to authorize a geodatabase. That is why I mentioned ArcGIS for Server. Vince asked a great question above... perhaps you could provide the error you're getting or a screenshot of what you're seeing.

Re: number of session exceeded

VinceAngelo — Fri, 04 Apr 2014 12:23:10 GMT

There's two types of Express-based geodatabases, the Desktop geodatabase, with 3 seats,
and the Workgroup database with 10 seats. You seem to be using the former.

- V

Re: number of session exceeded

yousradaoudi — Fri, 04 Apr 2014 12:37:00 GMT

There's two types of Express-based geodatabases, the Desktop geodatabase, with 3 seats,
and the Workgroup database with 10 seats. You seem to be using the former.

- V

can you just specify for me how can i make a difference betweet this versions

Re: number of session exceeded

VinceAngelo — Fri, 04 Apr 2014 12:40:43 GMT

Well, if you didn't use a Workgroup keycode, and it limits you to three users,
then you're not using Workgroup.

- V

Re: number of session exceeded

AsrujitSengupta — Fri, 04 Apr 2014 15:24:55 GMT

Yousra,

Open SQL Server management Studio--> Connect to the instance-->Expand the concerned Database-->Expand tables--> Look for a table named Server_config--> R-click on that and 'Select Top 1000 Rows'--> Check the parameter "AUTH_KEY"

if the license string starts with:
1)sdepersonal......--> its a sde personal geodatabase (free with ArcGIS Desktop and has a connection limit of 3 users at a time)
2)sdeworkgroup....--> its a sde workgroup geodatabase
3)arcsdeserver.....--> its a sde enterprise geodatabase

My guess, you are using the SDE Personal and thus observing this limitation.

Re: number of session exceeded

AsrujitSengupta — Fri, 04 Apr 2014 15:28:18 GMT

Refer this link for more info:

Multiuser Geodatabase
http://www.esri.com/software/arcgis/geodatabase/multi-user-geodatabase

Re: number of session exceeded

yousradaoudi — Sun, 06 Apr 2014 17:03:44 GMT

here is the error message that i get
[ATTACH=CONFIG]32847[/ATTACH]

thanks for ur help

Re: number of session exceeded

NidhinKarthikeyan — Mon, 07 Apr 2014 06:33:09 GMT

You receive this error because you are using Multiuser Desktop(1 editor and 3 readers) Geodatabase. If you want more users to connect to the Geodatabase, you have to get a Workgroup GDB (10 editors and readers) or an Enterprise GDB (Unlimited editors and readers).

Re: number of session exceeded

yousradaoudi — Mon, 07 Apr 2014 08:56:13 GMT

You receive this error because you are using Multiuser Desktop(1 editor and 3 readers) Geodatabase. If you want more users to connect to the Geodatabase, you have to get a Workgroup keycode (10 editors and readers) or an Enterprise GDB (Unlimited editors and readers).

please can you explain more about what you said ,because i m using arcgis desktop 10.2 sql server express , and in an other machin i have arcgis server 10.1 workgroup edition so how can i use arcgis server to have more connection to my geodatabase

Re: number of session exceeded

NidhinKarthikeyan — Mon, 07 Apr 2014 09:14:41 GMT

What I meant was Workgroup GDB. Right now you are using Desktop GDB and once more than three connections are made to the database, you encounter error. If you want to make more connections to the database, you have to use either Workgroup GDB or Enterprise GDB. Please refer this webpage.

Re: number of session exceeded

yousradaoudi — Mon, 07 Apr 2014 09:28:30 GMT

What I meant was Workgroup GDB. Right now you are using Desktop GDB and once more than three connections are made to the database, you encounter error. If you want to make more connections to the database, you have to use either Workgroup GDB or Enterprise GDB. Please refer this webpage.

thanks for responding but how can i create a workgroup gdb here how i create mine: i connect to my database server (sql server) then i create my gdb if there is an other way to do it please show it to me and thanks again

Re: number of session exceeded

NidhinKarthikeyan — Mon, 07 Apr 2014 09:33:08 GMT

Enabling SQL Server Express to store workgroup geodatabases.

Re: number of session exceeded

MarcoBoeringa — Mon, 07 Apr 2014 12:08:14 GMT

thanks for responding but how can i create a workgroup gdb here how i create mine: i connect to my database server (sql server) then i create my gdb if there is an other way to do it please show it to me and thanks again

Yousra,

You probably followed the instruction I gave here to create an ArcSDE Personal Server (a.k.a. Personal ArcSDE, a.k.a. Desktop Geodatabase). ArcSDE Personal Server doesn't allow more than 3 connections, even though SQL Server Express does, this is a build-in restriction by ESRI in order to prevent you from using it outside its intended scope, that is, just for "personal" and not "organizational" wide usage.

You can see if you are running an ArcSDE Personal Server (or otherwise), by right clicking the Database Server connection in ArcCatalog, and choosing Properties. It will open a dialog showing the type of ArcSDE server you have (in your case most likely it will thus read "ArcSDE Personal Server", see also the example I posted here).

Workgroup ArcSDE is NOT available as a free option, you have to buy / license it from ESRI, just like Enterprise ArcSDE. In order to license it, you will need a license for ArcGIS for Server, of which ArcSDE is part. ESRI will give you a license file once you've bought it.

In order to create the Workgroup Geodatabase, follow the link Nidhinkn pointed out in the previous post in the thread. Please note that, as with the Desktop Geodatabase instructions I gave, you don't need to reinstall SQL Server Express if you have it already installed, you just need to start the ESRI supplied "ArcGIS for Server Workgroup" installer, and then skip the actual step of installing SQL Server Express and go on with the authorization.

In case of an Enterprise Geodatabase, you will have to use the Create or Enable Enterprise Geodatabase tools and insert / use the license with these tools to create the Enterprise Geodatabase.

Personal ArcSDE, a.k.a. Desktop Geodatabase, a.k.a. ArcSDE Personal Server is free, and doesn't require a license file, but it is only included as part of ArcGIS for Desktop Standard and Advanced. You can not run an ArcSDE Personal Server using ArcGIS for Desktop Basic.

In order to create a Desktop Geodatabase, you don't use the Create or Enable Enterprise Geodatabase tools, but need to follow the instructions I posted here:

Steps to install "Personal ArcSDE / Desktop Geodatabase"

Re: number of session exceeded

MarcoBoeringa — Mon, 07 Apr 2014 15:48:01 GMT

please can you explain more about what you said ,because i m using arcgis desktop 10.2 sql server express , and in an other machin i have arcgis server 10.1 workgroup edition so how can i use arcgis server to have more connection to my geodatabase

If you already have the "Workgroup" level license, than Nidhinkn pointed out the way to use it to authorize your database for up to 10 concurrent users, instead of the 3 of a Desktop Geodatabase you have now:

Enabling SQL Server Express to store workgroup geodatabases.