laptop and a wrench

Bug

A map service published from a query layer fails to display and query when the database connection is registered over OS (operating system) authentication.

Last Published: November 21, 2017 ArcGIS for Server
Bug ID Number BUG-000100530
SubmittedNovember 1, 2016
Last ModifiedMarch 30, 2022
Applies toArcGIS for Server
Version found10.4.1
Operating SystemWindows OS
Operating System Version2012 R2
Version Fixed10.6.0
StatusFixed

Workaround

Remove the database name from the query string in ArcMap.1. Add the query layer to the MXD.2. Right-click the query layer in the Table Of Contents > Properties.3. In the Source tab, click 'Change Query'.4. By default, the query is displayed as the following:select OBJECTID, NAME, Shape from geodatabase.dbo.Buildings5. Change the query to remove the database name:select OBJECTID, NAME, Shape from dbo.BuildingsAfter publishing the service, the data displays or queries as expected.

Steps to Reproduce

Bug ID: BUG-000100530

Software:

  • ArcGIS for Server

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback