topic Re: Cannot Register the Managed Database for ARCGIS Server in ArcGIS Enterprise Questions

Cannot Register the Managed Database for ARCGIS Server

AdamEryavec — Tue, 16 Jul 2019 20:38:04 GMT

Hello,

When trying to register the managed database for the ArcGIS server 10.5 through ArcCatalog it appears successful and will validate, but in the logs I get error 7415 (Failed to update the data store connections file, Registration of database is incomplete, Please re-register database).

When I subsequently try to deploy a FeatureService through ArcMap it fails with error 001369 (failed to create service) after failign to get the server's server only enterprise database.

I have tried changing the permissions on the config-store folder to give full control to all, and have also tried changing to a fresh config-store folder.

I have tried restarting the server, and unlocking and restarting the publishing tools service.

For the connection to the enterprise geodatabase I have tried connecting with the sde user, the sa user, and the ./arcgis service account user.

This occured when I was trying to connect to a freshly created geodatabase (which I did while working a separate issue) - I have been able to register the database and deploy feature services on this machine before.

Any help would be greatly appreciated, thank you.

Re: Cannot Register the Managed Database for ARCGIS Server

ThomasColson — Thu, 18 Jul 2019 13:01:03 GMT

"freshly created geodatabase"

What errors are throwing in the SQL Logs?

Run a trace and SDE intercept. Anything obvious?

https://www.esri.com/news/arcuser/0102/sqlprofiler1of2.html

https://www.esri.com/news/arcuser/0102/sqlprofiler2of2.html

https://support.esri.com/en/technical-article/000010355

Your problem is permissions.

Re: Cannot Register the Managed Database for ARCGIS Server

AdamEryavec — Thu, 18 Jul 2019 20:49:00 GMT

I created a geodatabase again with the Create Enterprise Geodatabase tool, with the OS user as the db admin and sde owned schema enabled. When registering I use SQL security for the connection with the sde login. When I specify Windows security I immediately get a Bad Login User popup.

I reproduced the error again with the profiler and SDE intercept enabled:

SQL Profiler and SDE Intercept did not show any errors. I also didn't see any errors in the SQL logs. However when I increased the ArcGIS Server log level I got the additional info "Backup copy of data store connections file does not exist". This makes me think the issue is possibly with the configuration store?

Re: Cannot Register the Managed Database for ARCGIS Server

AdamEryavec — Tue, 30 Jul 2019 12:41:29 GMT

Reproduced the problem for ESRI support to investigate. dsconnections.lst was not being created or updated in either location for uncertain reasons. Error was resolved by reinstalling ArcGIS server but using the same geodatabase.