AnsweredAssumed Answered

User unable to establish a connection to a SQL Server Database from ArcMap.

Question asked by kjxm25_KCSouthern on Jan 14, 2020
Latest reply on Jan 14, 2020 by George_Thompson-esristaff

We have a user in our organization that is unable to access our SQL Server databases.  All other users are able to access the databases.  They are authenticating in using operating system authentication.  I had the person try connecting from my machine and she was able to get in, so we have ruled out the issue being due to permissions.  We also confirmed that she has the proper SQL Server Client and ODBC driver installed.  Our databases are running under SQL Server 14 and the driver she is using is Microsoft ODBC Driver 17 for SQL Server.  She also has the SQL Server 2012 Native Client installed.  I have read through the documentation and we appear to have everything installed that needs to be.  She did have the driver installed on her machine prior to running the ArcMap installation.  She has other applications that use the driver.  The only other thing I can think of is a setting not being correct in the Registry.  Is there anything else that might be causing the error?  We have been instructed to rerun the Desktop installation if we cannot resolve the issue but I am afraid that might not fix the error.  The error returned by ArcMap states "Failure to access the DBMS server".         

Outcomes