topic Re: Cannot connect to SQL database from Pro in ArcGIS Pro Questions

Cannot connect to SQL database from Pro

HanliePetoors — Wed, 21 Sep 2022 07:00:16 GMT

Hi,

I'm working with

Connecting to SQL databases worked fine until I installed ArcGIS Server 10.9.1 on the same computer.

Now I get the following error:

ArcGIS Ddesktop 10.8.2 has a similar issue:

I have uninstalled ArcGIS Server, uninstalled Pro an re-installed Pro but the problem persists.

I have Microsoft ODBC drivers 13 and 17 installed.

Can anyone help me fix this problem?

Thanks

Hanlie

George_Thompson — Wed, 21 Sep 2022 11:21:19 GMT

Have you enabled the Enterprise Geodatabase on that SQL Server DB that you are connecting to?

The error message seems to indicate that the license in the EGDB is invalid.

Can you connect as the SDE user?

HanliePetoors — Wed, 21 Sep 2022 11:28:03 GMT

You've nailed it, thanks.

When I connect with the sde user it asks for an authorization file and when I provide it, I can get in.