topic Re: Unable to register SDE database with ArcServer in ArcGIS Enterprise Questions

Unable to register SDE database with ArcServer

AllenScully — Fri, 07 Apr 2017 18:32:54 GMT

Working in 10.4.1 -

Started having publishing problems on an ArcServer machine, got many add messages about ArcMap on that machine being corrupt and some SQL Native client issues. All that has been fixed by ensuring proper version of client is installed and the desktop is working correctly - database connections working, adding layers is fine.

However when I go to register the database with the server, I see the following:

Stumped by this one - it seems to be configured the same as our other functioning ArcServer machines and am not sure how to research this error (no code)

Thanks -

Allen

Re: Unable to register SDE database with ArcServer

Anonymous User — Fri, 07 Apr 2017 18:43:34 GMT

Allen,

Did you create a new connection to the database in ArcMap after installing the proper version of the client? Did you open up a new session of ArcMap? Also, are you able to register the database via ArcGIS Server Manager?

Re: Unable to register SDE database with ArcServer

AllenScully — Fri, 07 Apr 2017 18:50:05 GMT

Thanks Dan -

Yes, I created new database connections, as well as a new server connection in Catalog, fresh session of arcmap. All appears normal until I go to register.

Registering the database through server manager fails as well: (I navigated to the sde connection file to import - this is the result. that database connection works in arcmap)

Allen

Re: Unable to register SDE database with ArcServer

Anonymous User — Mon, 10 Apr 2017 14:46:54 GMT

What version of SQL are you using?

Are the following patches installed on the Server machine?

ArcGIS 10.4.1 for (Desktop, Engine, Server) SQL Server Quality Improvement Patch

Esri Support 10.4 (10.4.1)

ArcGIS 10.4.1 for (Desktop, Server) SQL Server Mixed Precision Patch

Esri Support 10.4 (10.4.1)

Do you have the same issue if you create a new enterprise geodatabase and register that geodatabase to your ArcGIS Server?

Re: Unable to register SDE database with ArcServer

AllenScully — Mon, 10 Apr 2017 16:18:07 GMT

Did not have those patches installed - installed the Server versions of both this morning and was able to register an SQL Server SDE database and publish successfully. Looks like that did it.

Thanks -

Allen

Re: Unable to register SDE database with ArcServer

Anonymous User — Mon, 10 Apr 2017 17:22:45 GMT

That's great! Glad to know that fixed it!

Re: Unable to register SDE database with ArcServer

RebeccaStrauch__GISP — Mon, 10 Apr 2017 17:26:23 GMT

Allen, remember to mark Dan's response as the correct answer so this thread can be closed. Thanks.