Select to view content in your preferred language

Can not register database to ArcGIS Server from SQL Server

4897
9
09-09-2014 09:04 PM
NandhyPoetri
New Contributor

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

0 Kudos
9 Replies
AsrujitSengupta
Regular Contributor III

Which user are you using to register the database?

0 Kudos
NandhyPoetri
New Contributor

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

0 Kudos
AsrujitSengupta
Regular Contributor III

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

0 Kudos
NandhyPoetri
New Contributor

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

0 Kudos
AsrujitSengupta
Regular Contributor III

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.

0 Kudos
NandhyPoetri
New Contributor

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

0 Kudos
AsrujitSengupta
Regular Contributor III

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
New Contributor III

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

0 Kudos
ArcGIS_OnlineAdmin
New Contributor II

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

 

0 Kudos