The connection property set was missing a required property or the property value was unrecognized

Error Message

Attempting to create a data store using an SDE file returns the following error message:

Error:   
The connection property set was missing a required property or the property value was unrecognized. Connection was attempted with an older version of SQL Server client communications software that is not supported.

Cause

• The ArcGIS Server Windows service account does not have read permissions to the data stored in folders, databases, or in enterprise or workgroup geodatabases accessed with operating system authentication.
• There is no Microsoft ODBC driver installed on the client machine.
• This error may also occur in ArcGIS Enterprise on Linux Ubuntu machines where the unixodbc-dev package has not been installed (in addition to the msodbcsql package).

Solution or Workaround

Depending on the cause, choose one of the workarounds below to resolve.

The ArcGIS Server Windows service does not have read permissions

Refer to Error: The ArcGIS Server is not able to connect to the specified directory for instructions to apply read permissions to the appropriate folder.

Install the Microsoft ODBC driver on the client machine

1. Log in to My Esri.
2. Navigate to My Organizations > Downloads > Products. Search for ArcGIS Enterprise (Windows), select the version from the Version drop-down list, and click View Downloads.
3. In the Download Components pane, expand Database Support Files, and search for the appropriate Microsoft ODBC driver. Click Download.
4. Run the Microsoft ODBC driver installer to install the driver.

In Linux environments, refer to Microsoft's documentation for installing ODBC drivers and Esri's documentation for connecting to SQL Server from ArcGIS Server.

The SDE file can now be used to create a data store.