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?

[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_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#E...

[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#ES...

[RyanUthoff · Accepted solution]

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.