topic Re: Connection to SQL Server is not pushing through in ArcGIS Pro Questions

Connection to SQL Server is not pushing through

AngelNicoleAlvaro1 — Wed, 13 Mar 2024 04:55:10 GMT

Hi, we are trying to connect to SQL Server database to load the existing data. We've tried updating the Pro and installing the latest patch. Uninstalled and installed the ODBC Driver for SQL Server, but it seems that the connection is still loading and is not pushing through. We are using ArcGIS Pro 3.2.2 and SQL Server 2017. Enterprise setup was installed in Linux OS, but Pro is installed in Windows. Has anyone experienced the same problem? What can we do about this? Thank you in advance.

Re: Connection to SQL Server is not pushing through

George_Thompson — Wed, 13 Mar 2024 10:47:16 GMT

Just so I am clear, you cannot connect with ArcGIS Pro to SQL Server at all. Is there any error message, if so please provide?

Are you using the Microsoft ODBC Driver 17 for SQL Server?

Is SQL Server installed on Linux or Windows O/S?
You mention Enterprise, but need clarification on this.

Is there all ready an enterprise geodatabase or just a SQL database on that instance?

Re: Connection to SQL Server is not pushing through

AngelNicoleAlvaro1 — Fri, 15 Mar 2024 01:27:37 GMT

Hi, George! There is no error appearing when we try to connect to SQL Server, just the loading line. We have installed MS ODBC Driver 17. SQL is installed in Linux. I just mentioned the Enterprise part because I'm not sure if it will help. We're trying to connect first to the database from SQL Server to access data.

There is an update to our problem though. It appears that the system tables that come with the back up file was corrupted. My colleague deleted those corrupted tables and it finally connected.

Re: Connection to SQL Server is not pushing through

George_Thompson — Fri, 15 Mar 2024 11:21:35 GMT

If you create a new enterprise geodatabase (or database) are you able to connect to it and load / view data?

If you deleted the system tables, that could cause additional issues.

Re: Connection to SQL Server is not pushing through

AngelNicoleAlvaro1 — Mon, 18 Mar 2024 02:47:55 GMT

Hi, George. We'll try creating a new enterprise gdb and we'll load the data there. We'll check if this works. Thank you!

Re: Connection to SQL Server is not pushing through

AngelNicoleAlvaro1 — Mon, 18 Mar 2024 02:50:21 GMT

Another concern of ours was the client sent a .bak file of the data and from what we know, we have to restore this first in the same DB which was SQL Server. We restored this in SQL and we are now trying to connect to that same DB in Pro.

Re: Connection to SQL Server is not pushing through

George_Thompson — Mon, 18 Mar 2024 11:24:39 GMT

After you restore the backup to SQL Server, you must create the users to match what is in the restored database. Once the users are in the SQL instance you must re-sync the logins from the database to the instance: https://support.esri.com/en-us/knowledge-base/re-synch-sql-server-logins-or-users-after-restoring-a-d-000008079

That should allow you to connect as those users. If the restored database is all DBO, then a DBO users on the new instance should be able to connect.

Re: Connection to SQL Server is not pushing through

AngelNicoleAlvaro1 — Tue, 19 Mar 2024 03:49:51 GMT

Hi, George! Update. We tried creating an EGDB and loading/restoring the data there but it failed.

We'll try restoring it again on SQL Server and create users to match what is in the restored DB.