Can't publish a map service: Joining a Point file to a separate SQL table

Question

I have added a SQL query layer (Server3) to my mxd and have joined it with a point layer (server4). I have registered that separate SQL DB(server3) along with server4 to the data store. When I go to publish the Service I get error 00062. Is there a way to connect/join to the SQL table to the points so I can view that information through portal as a feature layer.

Thanks

DanielPaul · Answer

I did that but when I click on a point the pop up reads no information available

JakeSkinner · Answer

Hi Daniel,

From the help:

Feature services require that all layers and stand-alone tables in the service reference an enterprise geodatabase or a standard enterprise database using a single connection.

If you don't need to edit the data, you can uncheck 'Feature Access' and you should be able to successfully publish the service.