nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error connecting to Workgroup Geodatabase

HaniDraidi

I am trying to connect to a Workgroup Geodatabase, when trying to exploring this geodatabase I get an error that says: “Failed to connect to database. Maximum Number of connections to instance is reached”. However, only three users are connecting to this geodatabase which is less than the TEN allowed users.

What might be the issue here?

Thank you and Best Regards,

Find more posts tagged with

Accepted answers

George_Thompson

It should be something like this..... "Database_Server_Workgroup_1031"

Make sure that you have a license for the following product: ArcGIS Server for Workgroup (any license level: Basic, Standard or Advanced)

That should get you moving.....

All comments

HaniDraidi

Hi Asrujit,

Thank you for the helpful contribution!

Actually, I got confused. I came from the enterprise geodatabase environment, and new to the Workgroup GDB; when I create an enterprise geodatabase, or enable an enterprise database to be enterprise GEODATABASE, I am asked to provide an authorization file (in the screen shots below). However, in the case of Workgroup GDB, I can create it without providing any authorization (in the third screenshot). At what level should I authorize the workgroup geodatabase? May you please explain?

May you please also elaborate how can I check the Server_config table in SQL Server Management Studio (My experience with SQL Server is shallow)?

Best Regards,

1- Creating an enterprise Geodatabase; it Asks for an authorization file

2- Enabling enterprise Geodatabase; it also asks for the authorization file

3- Creating a Workgroup Geodatabase; it DOES NOT ask for any authorization file!

AsrujitSengupta

You need an SDE Workgroup license for enabling an instance before creating a sde workgroup geodatabase.

From your description, it seems that you are using an SDE Personal gdb, which has a limitation of 3 connections..

As suggested in my last post, please check the Server_config table in SQL Server Management Studio

HaniDraidi

Hi Asrujit,

Regarding the license I used no license for authorizing this Geodatabase, since it is a Workgroup GDB; I connected to the database server, and created it (in ArcMap), and it did not ask me for any license.

Regarding the number of connections, I had only 3 connections with NO map services connected to this GDB.

Best,

AsrujitSengupta

Some things I would recommend to check:

1. The Server_config table for the license which was used to authorize the geodatabase. Check the AUTH_KEY parameter value.

2. The process_information table for the actual number of connections to the geodatabase, when you get that message.

Do you have Map Services running for that geodatabase? It could be consuming connections too.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.