00140: Layer's database connection user name does not match any SDS data source user name

You are publishing to a Java spatial data server (SDS) and the user name for this layer's database connection does not match the user name for any of the data sources listed with the SDS server.

Solutions

• Contact the SDS sever administrator and request that an additional data source containing the same user name as the layer's database connection be added to the SDS server.

  Learn how to create data source mapping from the REST endpoint for ArcGIS Spatial Data Server for Java

• Or, you can change the layer's database connection so that it uses a user name of one of the data sources that already exist on the SDS server.

  First, find out what user name you need to use by viewing the properties of the data sources listed with the SDS server.

  1. From ArcCatalog or the Catalog window in ArcMap, locate the spatial data server connection and double-click to connect.
  2. Right-click the connection and choose Server Properties.

     The SDS Server Properties dialog box opens.

  3. Choose the data source you want to map from the Data Sources tree view.

     This list is populated with the data sources registered with the spatial data server. You can see this list by navigating to the REST endpoint http://<server>:<port>/arcgis/admin/datasources. This is the user name you want your layer to use when referencing the original database.

  4. Once you have the user name, you will need to make a new connection with this user name to the original database and set your layer's data source to use this connection.

  Learn more about connecting to an enterprise geodatabase, database connections in ArcGIS for Desktop, and setting data sources for layers

More information

When publishing to Java SDS server, ArcGIS finds any data sources listed with the SDS server that match the layer's database connection. This includes matching user names. Once a match is identified, a data source mapping is created using the workspaces connection string. Data source mappings are used to identify which data source is to be used by the SDS service.

Learn more about authoring feature services for a spatial data server (SDS)