Create a spatial view that uses tables from a linked server

140
0
06-21-2019 01:02 PM
JakeNeedle
New Contributor III

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?

0 Kudos
0 Replies