00078: Data source connection is using operating system authentication

In this topic

Solution
More information

The connection to your layer's data source uses operating system (OS) authentication and you are attempting to publish to service with Feature Access (feature service) enabled.

Solution

If you are working with a query layer, follow these steps.
1. Right-click the query layer in the table of contents and click Properties.
2. Click the Source tab.
3. Click Change Query.
4. Click Connections.
5. Click the connection and click Edit.
6. Navigate to the database connection you just updated and double-click it.
7. Click the Authentication drop-down arrow and click Database Authentication.
8. Click OK.
9. Repeat for each query layer in the data frame.
If you are working with a feature layer, follow these steps.
1. Open ArcCatalog or the Catalog window in ArcMap.
2. Right-click the database connection and click Connection Properties.
3. Click Database Authentication and enter a user name and password. See the database administrator if you do not know the appropriate user name and password.
4. Click OK.
5. Right-click the layer in the table of contents and click Properties.
6. Click the Source tab.
7. Click Set Data Source.
8. Navigate to the database connection you just updated and double-click it.
9. Double-click the dataset for the layer.
10. Click OK.
11. Repeat for each layer in the data frame.

Caution:

Changing connection properties manually through the Database Connection dialog box does not affect the layer. It only affects the database connection. If you change connection properties manually, you will need to either remove the layer added with the original connection using OS authentication and add it back using the connection using database authentication. You can use arcpy.mapping to automate this.

Learn more about updating data sources with arcpy.mapping

Clicking the solution Edit connection properties from the context menu from the Prepare window will automatically update the layers with the change you make.

More information

OS authentication indicates a user logs in to the computer, and the credentials for authorization are supplied to the database by the operating system of the user's computer.

Database authentication indicates a user logs in to the server, then must separately log in to the database using database user names and passwords, which the database administrator must create.

Feedback on this topic?