topic Re: Failed to access the DBMS in ArcGIS Enterprise Questions

Failed to access the DBMS

SoratoSouza_e_Silva — Fri, 05 Jul 2019 21:10:40 GMT

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

Re: Failed to access the DBMS

JonathanFarmer_oldaccount — Fri, 05 Jul 2019 21:51:02 GMT

Hi Andre,

Before I delve into specifics, can we hash out the versions of things you are using? You are working with SQL Server 2012, any service packs installed? What version of Desktop and Server are you using?

Next, where are you trying to register this database from? Server Manager? ArcMap? Pro?

SQL Server is unique in that you can install the 64 bit client and connect to both 32 bit and 64 bit applications. So, I always recommend folks just install the 64 bit client on their desktop client machines as well as their ArcGIS Server machines. Is that what you have done here? If not, what is your current situation? It's a little hard to tell from the original post.

Jonathan

Re: Failed to access the DBMS

SoratoSouza_e_Silva — Sat, 06 Jul 2019 00:59:11 GMT

Hi Jonathan,

Thank´s for your attention!

I´m using Windows 7 (both) client and server. Database is SQL Server Express 2012. I´m using ArcMap (10.5.1) for publish.

My ArcGIS Server is 10.5.1 and Itried to publish by server also, but the problem happens too.

I installed client 64 in both machines, but work properly in the machine where sql server was installed.

I tried to use ODBC also, but unsuccessfully

Now I have the image previous show!

Thank´s for your help

Re: Failed to access the DBMS

JonathanFarmer_oldaccount — Mon, 08 Jul 2019 14:29:28 GMT

Andre,

It sounds like you are trying to register this database with ArcGIS Server when you are publishing from ArcMap. But what happens if you try to register it from Server Manager? Same failure?

https://enterprise.arcgis.com/en/server/10.5/publish-services/windows/registering-your-data-with-arcgis-server-using-manager.htm

Re: Failed to access the DBMS

SoratoSouza_e_Silva — Mon, 08 Jul 2019 14:59:17 GMT

Hi Jonathan,

The same failure happen unfortunately!

FAILED TO ACCESS THE DBMS

Can help me?

Re: Failed to access the DBMS

JonathanFarmer_oldaccount — Mon, 08 Jul 2019 15:05:15 GMT

Andre,

These errors mean that ArcGIS cannot communicate with your database.

What happens if you ping your database machine from your ArcGIS Server machine? Can they communicate? Can you telnet over the default SQL Server port (1433)?

It may be beneficial to open a support case on this as there is only so much we can do here.

Re: Failed to access the DBMS

LanceCole — Mon, 08 Jul 2019 15:24:23 GMT

André Souza

Can you show more of the connection dialog when you are creating the connection and not just the error?

As Jonathan Farmer‌ noted, check for connection between the two systems via ping and telnet. Check the ping for both IP and FQDN.

Do you have a firewall between the two systems or could they be running of different subnets/vlans?

Is port 1433 open and is this the port the SQL server is running you are trying to connect to? Especially if not running on the default version.

Re: Failed to access the DBMS

SoratoSouza_e_Silva — Mon, 08 Jul 2019 17:41:45 GMT

Both firewalls are turned off, ping verified between ok! But only by IP, because no DNS configured. The 1433 port is on in database,..I do not know what to do anymore!!

Re: Failed to access the DBMS

LanceCole — Mon, 08 Jul 2019 18:21:19 GMT

André Souza

As you do not have DNS enabled, have you tried to connect using the IP address of the server rather then the server name?

Re: Failed to access the DBMS

SoratoSouza_e_Silva — Mon, 08 Jul 2019 18:29:01 GMT

YES! Correct! By IP work very well. The communication is open.

Re: Failed to access the DBMS

JonathanFarmer_oldaccount — Mon, 08 Jul 2019 19:26:50 GMT

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

Re: Failed to access the DBMS

SoratoSouza_e_Silva — Mon, 08 Jul 2019 19:37:40 GMT

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

Re: Failed to access the DBMS

ThomasColson — Wed, 10 Jul 2019 11:44:26 GMT

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-system-authentication, how is your SQL database engine authenticating, does your GIS server account have the correct permissions?

Re: Failed to access the DBMS

SoratoSouza_e_Silva — Wed, 10 Jul 2019 17:03:11 GMT

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

Re: Failed to access the DBMS

ThomasColson — Wed, 10 Jul 2019 17:30:54 GMT

Ahha!

Please share a screen shot like the following:

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

Re: Failed to access the DBMS

SoratoSouza_e_Silva — Wed, 10 Jul 2019 20:34:19 GMT

Thomas,

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

Re: Failed to access the DBMS

ThomasColson — Thu, 11 Jul 2019 11:04:13 GMT

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.

Re: Failed to access the DBMS

SoratoSouza_e_Silva — Thu, 11 Jul 2019 16:54:48 GMT

There are no firewalls and antivirus in both machines