AnsweredAssumed Answered

Publishing Services from direct connection to SQL Server 2014

Question asked by t0rnado on Sep 8, 2016
Latest reply on Oct 23, 2017 by CGSJohnson

I have data loaded into a SQL Server 2014. I have validated the connection to the data source in ArcGIS Server 10.4.1.


I can add geographic data to an ArcMap Client and publish to Server.


When trying to view the data from the rest service page the geometry is not displayed and I receive the following error in the Server logs.


There is an error during the draw WISE_Decade_CBAS.DBO.deleteme (1.) DBMS table not found[42S02:[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name 'WISE_Decade_CBAS,(2.) WISLEG\SA-DEV-ARCGIS,(3.) deleteme',(4.) ].


We do not seem to have this same problem in our 10.3.1 environment. I do see the geometry in ArcMap!

I am also not seeing the same behavior in our SDE based environment.