I get an underlying DBMS failure when trying to register the MS SQL 2012 with the Linux version of ArcGIS Server 10.31
That is correct, to use SQL Server as the RDBMS as your choice you need to use Server on Windows and NOT Linux.
Please contact Esri Technical Support and create a case if you have any more questions about this configuration.
I don't have much experience with ArcGIS Server on Linux, but does the ArcGIS Server Account have read privileges to the enterprise geodatabase and the connection file?
I have a valid connection file I can use in Arc Catalog.
I am trying to import that file into the Server to Register the DB.
Take a look at the following link:
About registering your data with ArcGIS Server—Documentation (10.3 and 10.3.1) | ArcGIS for Server
Do you know if your ArcGIS Server Account is a local user, or a domain user?
It's a local user.
I don't see where it talks about Registering a Microsoft SQL 2012 server with the ArcGIS server.
Also, the ArcGIS server is on a Linux OS, not a windows.
I tried to register the same ArcCatalog .sde file with an ArcGIS Server 10.41 on Windows.
It failed for the same reason.
I then installed the MS SQL 2012 Native Client on the ArcGIS server on Windows.
After rebooting, I am able to register the .sde file successfully.
Where can I find the same MS SQL 2012 Native Client used on the Windows OS for a Linux system?
I am not sure that you can register a SQL Server geodatabase to Server on Linux.
Here is a list of supported databases for ArcGIS Server 10.4.x on Linus: ArcGIS 10.4.x for Server system requirements—Installation Guides (10.4.1) | ArcGIS for Server
You cannot connect to SQL Server from ArcGIS for Server on Linux.
Hope this clears up any confusion.
Also update your other post.
Geodatabase ArcGIS Enterprise
ESRI does not support a solution where the ArcGIS Server is on Linux and SDE or a standard DBMS uses MS SQL running on windows?
Shouldn't this be in bold type at the beginning of deciding how to deploy an ArcGIS server?
i.e. You must go windows if you want to use MS SQL.
Esri Technical Support - Please tell me this is not true!
Retrieving data ...