Failute to access the DBMS server[] issues when trying to push a map service to ArcGIS server 11.5 on Linux.

Question

We have ArcGIS Server 11.5 on a RedHat Linux 9.  It was connected to MS SQL Server 2022, also on the same. Linux server.

I am accessing the service from my windows 11 desktop running ArcGIS 3.6 Pro.

I tried to publish a simple map service of a WGS1984 map, with 12 feature layers, that, together comprise a comprhensive base map for our project.

Upon analysis, I got this message:

The database is already registered, so i tried a few things to no avail.

I finally tried to reregister the database, using my local connection file, and got this message:

Things should be easier than this.

I am able to connect to the database using sde from my ArcGIS Pro.  I am also able to connect to the ArcGIS Server from my ArcGIS Pro.

The feature layers I am trying to publish are using tables from the ms sql database, and these table have been turned into FeatureClasses inside sde on the ArcGIS server.

I also did what turned out to be a foolish thing, which was to deregister the database using Server Manager and trying to reregister it.  I used the connection file from my windows 11 machine.

I now get this:

Its the same error at all three attempts.

Any guidance would be appreciated.

CalvinHarmin · Answer

This is a shot in the dark but is sa just the super-admin user for the SQL Server instance? Is it possible there is another user/schema that is the owner of the enterprise gdb? I recall when creating egdb's in SQL Server there are a couple different ways you can set up the schema model and maybe although sa can see everything, it may not behave the same as the actual database owner or other users with read/write permissions enabled within Arc- ecosystem.

VenkataKondepati · Answer

Please stop using Windows names.
Use IPs, use Database Authentication, and make sure the Linux ODBC drivers are installed on that RedHat 9 machine.
If the server can't "ping" the database internally, Pro won't be able to force the registration.

Does the RHEL 9 environment have the Microsoft ODBC drivers installed yet?