Failed to access the DBMS

[SoratoSouza_e_Silva]

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

[JonathanFarmer_oldaccount]

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 

[SoratoSouza_e_Silva]

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

[ThomasColson]

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/139759, https://community.esri.com/thread/168146, https://support.esri.com/en/technical-article/000012689, https://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? 

[SoratoSouza_e_Silva]

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

[ThomasColson]

Ahha! 

Please share a screen shot like the following: 

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

[SoratoSouza_e_Silva]

Thomas,

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

[ThomasColson]

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. 

[SoratoSouza_e_Silva]

There are no firewalls and antivirus in both machines