ArcMap fails to connect to SQL server machine that has real IP (domain name),

[JamalNUMAN]

ArcMap fails to connect to SQL server machine that has real IP (domain name),

Despite the fact that the SQL server database can be access with machine domain name and SQL logins, the ArcMap fails

What could be the issue here?

[Anonymous User]

Hi Jamal,

1. What version of ArcMap and SQL are you in? (SQL or SQL express)
2. Do you have the SQL server native client installed locally on your machine?

[JamalNUMAN]

Thank you for the answer

SQL Server: 2016 both on the server and client machines

ArcMap: 10.6.1

[George_Thompson]

Can you connect to the SQL instance geomolg.ps from you local SSMS install?

I see that you can access it locally from the VM that is hosting the SQL instance. I am wondering if it can be accessed remotely at all.

[JamalNUMAN]

Thanks George.

Do you mean that the SQL Server database can’t be accessed remotely (via internet but not over the network) if its machine has real IP? Is this by design?

[George_Thompson]

I am not sure what the "full" issue is yet.

Can you connect from SSMS on your local machine to the remote SQL install?

[JamalNUMAN]

For example, you will be able to access my sql server database from your machine if I provide you with the server real IP and database logins (user name\password)?

[George_Thompson]

Ok, I would recommend that you reach out to Esri Technical Support on this.

[Anonymous User]

Hi Jamal,

When I'm asking about the client, I'm referring to the additional software that is installed in order for ArcMap to connect to SQL.

https://www.microsoft.com/en-us/download/details.aspx?id=52676

Do you have this on your ArcMap machine? 

https://desktop.arcgis.com/en/system-requirements/10.6/database-requirements-sqlserver.htm

SQL Server 2016

• Microsoft ODBC Driver 17 for SQL Server
• Microsoft ODBC Driver 13 or 13.1 for SQL Server

[JamalNUMAN]

Hi Luba,

The screenshot below shows the version of SQL server database both in the server and client machine.