Select to view content in your preferred language

Failed to access the DBMS

2458
17
07-05-2019 02:10 PM
SoratoSouza_e_Silva
Frequent Contributor

HI,

I'm trying to register a database sql server 2012 that is in another VM. My bank is 64-bit, the OS on both machines is 64-bit, only Arcgis is 32.

I already installed the client on the machine that is my GIS Server, but nothing works. As the OS is 64 I can never install the 32 client obviously.

I have already tried setting up ODBC 64 bit, but there is also connection failure.

can anybody help me?

Thank´s

Tags (1)
0 Kudos
17 Replies
JonathanFarmer_oldaccount
Deactivated User

Just to clarify, you can connect to the database from ArcMap using the IP address but still cannot register using the IP address or can you actually connect ArcGIS Server to the database using the IP address (and register the database)? 

If you can register the database using the IP address but the machine name fails, check to ensure network discovery is enabled. I've seen this be the issue a few times.

https://superuser.com/questions/1068448/cant-access-pc-by-name-but-can-by-ip-address 

0 Kudos
SoratoSouza_e_Silva
Frequent Contributor

Hi Jonathan,

I can´t to register in ArcGIS Server in no way. I continue with the same error as failed to access the DBMS server

0 Kudos
ThomasColson
MVP Frequent Contributor

Before you can troubleshoot the GIS side of the issue, you need to isolate if 1433 is working correctly. Can you install SQL management Studio on the same computer, and can you connect to the database? In addition, it looks like service account permissions has been an issue in the past, https://community.esri.com/thread/74529, https://community.esri.com/thread/139759https://community.esri.com/thread/168146https://support.esri.com/en/technical-article/000012689https://gis.stackexchange.com/questions/166801/registering-a-database-on-arcgis-with-operating-syste..., how is your SQL database engine authenticating, does your GIS server account have the correct permissions? 

0 Kudos
SoratoSouza_e_Silva
Frequent Contributor

Thomas Colson

"Before you can troubleshoot the GIS side of the issue, you need to isolate if 1433 is working correctly. Can you install SQL management Studio on the same computer, and can you connect to the database? "

Yes I can. Now I had to install the database in the same GIS machine, to solve temporarily, but it is not what I look for as definitive.

The user have the correct previlegies. 

I'm not having problems with users, the problem is really connection, no software can connect to SQL Express from another machine.

Thank´s

0 Kudos
ThomasColson
MVP Frequent Contributor

Ahha! 

Please share a screen shot like the following: 

Is IPV4 Enabled? If so, try putting the loopback adapter as the IP. 

0 Kudos
SoratoSouza_e_Silva
Frequent Contributor

Thomas,

I made your changes, but the result is the same below:

0 Kudos
ThomasColson
MVP Frequent Contributor

Your issue is a SQL one, not an ESRI one. You'll have to solve "no software can connect to SQL Express from another machine" first. Disable firewall, antivirus, something is prohibiting SQL connections. I'd start with Microsoft tech support. 

0 Kudos
SoratoSouza_e_Silva
Frequent Contributor

There are no firewalls and antivirus in both machines

0 Kudos