topic Create a spatial view that uses tables from a linked server in Data Management Questions https://community.esri.com/t5/data-management-questions/create-a-spatial-view-that-uses-tables-from-a/m-p/363818#M20769 <HTML><HEAD></HEAD><BODY><P>I am trying to create a spatial view that uses tables from a linked server.&nbsp; 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:&nbsp; 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.&nbsp; Any ideas why this is error out when try to assess the view?</P></BODY></HTML> Fri, 21 Jun 2019 20:02:47 GMT JakeNeedle 2019-06-21T20:02:47Z Create a spatial view that uses tables from a linked server https://community.esri.com/t5/data-management-questions/create-a-spatial-view-that-uses-tables-from-a/m-p/363818#M20769 <HTML><HEAD></HEAD><BODY><P>I am trying to create a spatial view that uses tables from a linked server.&nbsp; 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:&nbsp; 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.&nbsp; Any ideas why this is error out when try to assess the view?</P></BODY></HTML> Fri, 21 Jun 2019 20:02:47 GMT https://community.esri.com/t5/data-management-questions/create-a-spatial-view-that-uses-tables-from-a/m-p/363818#M20769 JakeNeedle 2019-06-21T20:02:47Z