topic Not Able to Enable AllowConnection On ArcGIS Data Store in ArcGIS Enterprise Questions

Not Able to Enable AllowConnection On ArcGIS Data Store

BHK — Thu, 27 Mar 2025 16:11:03 GMT

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?

Re: Not Able to Enable AllowConnection On ArcGIS Data Store

RyanUthoff — Thu, 27 Mar 2025 17:16:51 GMT

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_xxxxxx 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

Re: Not Able to Enable AllowConnection On ArcGIS Data Store

BHK — Thu, 27 Mar 2025 19:42:50 GMT

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

Re: Not Able to Enable AllowConnection On ArcGIS Data Store

RyanUthoff — Thu, 27 Mar 2025 20:24:10 GMT

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_xxxxxx

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