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

Not Able to Enable AllowConnection On ArcGIS Data Store

BHK

Using AGE 10.9.1, I am trying to open a relational data store connection for my local machine using allowconnection ArcGIS Data Store utility reference

As you can see running the listmanageduser is returning this properly

but when I ran the allowconnection based on above information for User and Database

But I am getting this error 'A valid user name was not specified for the database.'

Can someone please let me know why this is happening?

Find more posts tagged with

Accepted answers

ryanuthoff

Well, in that example, it states that hqo.n_1E7 is the managed user. The dot notation (.) is a part of the username, and it isn't there to separate the username and database name. And also in that example, they don't even include the database name in the syntax because it's optional for the relational data store database.

Edit: Just to provide some further explanation, I'll walk through their example. They are wanting to allow a connection from a computer named workcom to connect to the relational data store (which is not named) as the hqo.n_1E7 managed user. Keep in mind that for the relational data store, the database name is optional. Therefore, the correct syntax is going to be: allowconnection workcom hqo.n_1E7

So in your case, you can input: allowconnection C1xxxx hsu_xyz

Since the database name is optional, you can just leave that out.

All comments

ryanuthoff

So in your case, you can input: allowconnection C1xxxx hsu_xyz

Since the database name is optional, you can just leave that out.

BHK

Thanks for comment Rayan but the command in the example syntax is using the dot notation (.) between the <username> and [<database>] like allowconnection workcom hqo.n_1E7

https://enterprise.arcgis.com/en/data-store/11.3/install/windows/data-store-utility-reference.htm#ESRI_SECTION1_BA475E64731246D4AD57055E4979111F

ryanuthoff

You blurred out your screenshot (which is good), but it also makes it a little more difficult to troubleshoot because I can't exactly see what you are inputting. However, I noticed you have a period (.) right before your database name. I don't believe there should be a period there, and I suspect that might be what is messing it up.

From Esri's documentation, the correct syntax should be: allowconnection <host name> <username> [<database>]

So, something like this: allowconnection C1xxxx hsu_xyz db_8xxxxx

I don't believe there should be any periods in there.

For reference: https://enterprise.arcgis.com/en/portal/10.9.1/administer/windows/data-store-utility-reference.htm#ESRI_SECTION1_BA475E64731246D4AD57055E4979111F

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.