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?
