Trouble publishing XY data that points to a SQL view

Discussion created by gis_tech on May 25, 2012
Latest reply on May 25, 2012 by
I've got an MXD with one data layer that draws points. This data layer uses a SQL view as the source for the XY data. It works just find in ArcMap but when I upload the MXD to ArcGIS Server to publish the service, the data layer is lost - it's not even listed in the REST endpoint. I'm using a projection of WGS 84 for the data layer and the data frame.

I'm totally stumped as to what's going wrong. Any/all help is much appreciated!