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.
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.