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; } } }

Adding users / roles to workgroup geodatabase created with MS SQL Server Express

HaniDraidi

I am not able to find how can I add a user to a workgroup geodatabase, as I do in an enterprise geodatabase (right click the geodatabase connection>administration>add user) as shown in the first screen shot. However there is no “add user” option in the administration options for a workgroup GDB created with Microsoft SQL Server Express and added to the geodatabase server (shown in the second screenshot)

Any help is highly appreciated

1- Adding a new user to an enterprise geodatabase

2- How can I add a new user to the workgroup geodatabase?

Finde mehr Beiträge mit dem Tag

Accepted answers

AsrujitSengupta

That will not work. The users should be a part of the same Domain when you are trying to add them to an Instance.

In your case, your PC seems to be a standalone PC on a network. It is not associated to any Domain.

All comments

HaniDraidi

Dear Asrujit,

Thank you very much for the helpful input,

Considering the points you highlighted above, I can say that: In addition to the traditional limitations of the workgroup GDB (limited number of concurrent users, limited storage capacity, number of licensable cores, …etc) there are two more limitations that the workgroup GDB has when comparing it with the enterprise Geodatabase:

1- The users/editors must be connected to a domain network.

2- When using ArcMap to connect to the database, the users/editors can only access the geodatabase only from their own machines (because they use windows users, unlike the users created in the enterprise GDB that use database users which can be accessed from any machine)

Do you agree with this?

Best,

AsrujitSengupta

That will not work. The users should be a part of the same Domain when you are trying to add them to an Instance.

In your case, your PC seems to be a standalone PC on a network. It is not associated to any Domain.

HaniDraidi

Thank you Asrujit for the helpful input,

I tried this and it worked with different users in the same machine (for example: hani-pc\hani, hani-pc\ahmed, and hani-pc\sami). However when adding users from other machines within the same network (for example: Asrujit-pc\Asrujit), I got the following error: "windows nt user or group not found. check the name again"

How can I resolve this problem?

Once again, Thank you for the prompt answer!

AsrujitSengupta

You need to Right Click on the instance connection first> Permissions> Add the login to the instance first

Then Right Click on the geodatabase> Administration> Permissions> Add the login to that geodatabase and grant necessary permissions

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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