A user in my organization just had an upgrade to ArcMap 10.8.1 and can now no longer connect to the Enterprise GDB using an SDE connection file (we tried OS authentication and a SQL built-in account). The user can still connect through Pro and was able to connect using the same file in 10.7.1. He also can make the connection successfully when logged into a VM with 10.7.1 installed. Has anyone seen this issue before?
SQL info - Microsoft SQL Server 2019, hosted on Azure.
You also need to make sure you have installed these two files:
Microsoft_ODBC_Driver_17_SQL_Server_64bit_167175 and
Microsoft_SQL_Server_2012_SP1_Native_Client_64bit_135448
Thank you,
Chad
Thanks for these suggestions - are these files needed specifically for ArcMap 10.8.1 connections or for 10.7.1 as well?
They work for 10.7.1 as well. Thank you, Chad
community.esri.com blog article
How to Install the SQL Server Client for ArcGIS?
ArcGIS requirements for SQL Server
Tip: For ArcGIS releases prior to 10.9 and ArcGIS Pro 2.8, see the system requirements on the ArcGIS Desktop website.
Had the same issue. On my dev-machine were ODBC version 13, 17 and 18 installed. After deinstalling everything except version 17 I could connect to my sde using arcmap 10.8.x.