AnsweredAssumed Answered

Failed to connect to database. Underlying DBMS error[IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedNo extended error.]

Question asked by COReGISAdmin on Sep 13, 2018
Latest reply on Oct 1, 2018 by COReGISAdmin

Failed to connect to database. Underlying DBMS error ODBC driver. ArcGIS for Server 10.4/ArcGIS Desktop 10.3.1/SQL Server 2014.

We have a new user in the GIS team. They have been added to the SQL roles required to read and edit objects in the enterprise databases (Windows Active Directory). The rest of the team have these roles and use an operating system connection to the databases to read and edit.. The new user was given the existing operating system connection files.

 When the new user tries to connect to the databases using the operating system connection in ArcMap or ArcCatalog they get an error
"Failed to connect to database. Underlying DBMS error[IM002:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedNo extended error.]" 
 When I give the new user  a database connection they can connect. Just not with the operating system connection they need to edit the objects in the databases. Existing users in the gisreader and giseditor SQL roles can sucessfully connect with the same operating system connection file.

Outcomes