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

555
9
06-27-2019 02:12 PM
JamalNUMAN
Esteemed Contributor

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?

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
9 Replies
LubaHristova
Esri Contributor

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
Esteemed Contributor

Thank you for the answer

 

SQL Server: 2016 both on the server and client machines

ArcMap: 10.6.1

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
George_Thompson
Esri Frequent Contributor

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.

--- George T.
JamalNUMAN
Esteemed Contributor

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?

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
George_Thompson
Esri Frequent Contributor

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

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

--- George T.
JamalNUMAN
Esteemed Contributor

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)?

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
George_Thompson
Esri Frequent Contributor

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

--- George T.
LubaHristova
Esri Contributor

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
Esteemed Contributor

Hi Luba,

 

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

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine