Can not register database to ArcGIS Server from SQL Server

[NandhyPoetri]

Hi....

I always fail to register my sqlserver to ArcGIS Server.

The following message was:

"The connection property set was missing a required property or the property value was unrecognized. Failed to access the DBMS server"

I can access the SQLServer from the database connection but can not register it.

Do you have suggestion for me?

Thank you

[AsrujitSengupta]

Which user are you using to register the database?

[NandhyPoetri]

I use the admin, but still can not register the database

[AsrujitSengupta]

which admin? a Windows login or a database authenticated login?

[NandhyPoetri]

Oh, the database login. Is there one of the reason I failed?

[AsrujitSengupta]

No, not really.

Try registering from ArcCatalog if you haven't already. Create a ADMIN server connection and then use that to try and register.

[NandhyPoetri]

Yeah, I have already done it, but I still have the same problem.

Hmm.. I did install the Native Client for SQLServer in server which I installed the ArcGIS Server.

In my case, the ArcGIS Server and SQL server are in different server.

Thank You

[AsrujitSengupta]

Did you install the 64-bit version of Native Client (assuming that your ArcGIS Server is a 64-bit machine)

40409 - Registering a database data store fails with 'Invalid database connection' or 'The data item...

Also, try to register using the IP Address instead of the Hostname an check if that helps.

[ShuhongYan]

I also have the same issue. Did you solve it finally?

[ArcGIS_OnlineAdmin]

Same issue as well using AGP 3.1.2 and ArcGIS Server 10.9.1. Anyone have any updates by chance?