nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

All comments

SoratoSouza_e_Silva

There are no firewalls and antivirus in both machines

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

Thomas,

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

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

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?

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

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

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

LanceCole

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?

SoratoSouza_e_Silva

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!!

LanceCole

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.

JonathanFarmer_oldaccount

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.

SoratoSouza_e_Silva

Hi Jonathan,

The same failure happen unfortunately!

FAILED TO ACCESS THE DBMS

Can help me?

JonathanFarmer_oldaccount

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

SoratoSouza_e_Silva

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

JonathanFarmer_oldaccount

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.