AnsweredAssumed Answered

Create a spatial view that uses tables from a linked server

Question asked by jtneedle on Jun 21, 2019

I am trying to create a spatial view that uses tables from a linked server.  When viewed in SQL Server Management Studio the queries run no problem, but if I try viewing them in Catalog or ArcMap i get the following error. "JakeTestDB.dbo.vwTeapot_Production_12Months:  Underlying DBMS error[HY000:[Microsoft][ODBC Driver 13 for SQL Server]Unspecified error occurred on SQL Server. Connection may have been terminated by the server.]" We are using ArcGIS 10.5 and SQL Server 2016.  Any ideas why this is error out when try to assess the view?

Outcomes