topic Re: Can not register database to ArcGIS Server from SQL Server in ArcGIS Enterprise Questions

Can not register database to ArcGIS Server from SQL Server

NandhyPoetri — Wed, 10 Sep 2014 04:04:09 GMT

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 — Wed, 10 Sep 2014 04:30:41 GMT

Which user are you using to register the database?

NandhyPoetri — Wed, 10 Sep 2014 04:35:39 GMT

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

AsrujitSengupta — Wed, 10 Sep 2014 04:39:29 GMT

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

NandhyPoetri — Wed, 10 Sep 2014 04:43:27 GMT

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

AsrujitSengupta — Wed, 10 Sep 2014 04:51:31 GMT

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 — Wed, 10 Sep 2014 04:57:59 GMT

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 — Wed, 10 Sep 2014 05:09:52 GMT

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

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

ShuhongYan — Wed, 22 Nov 2017 18:04:20 GMT

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

ArcGIS_OnlineAdmin — Thu, 15 Jun 2023 17:37:28 GMT

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