AnsweredAssumed Answered

Cannot add a View from SQL Server to Arcmap

Question asked by Zac.Wang on Jun 28, 2020
Latest reply on Jul 2, 2020 by Zac.Wang

Using SQL Server, I created a view in Database A by joining another view in database B on the same server. The process is successful in SQL Server Management Studio and the view looks all good.

 

But when I added this view to ArcMap(10.6.1), it occurred errors as shown below. The errors are too generic so I didn't know how to fix this issue.

 

From my understanding, ArcGIS allows user to create a view from two databases.

Though I also tired to create a view in ArcCatalog by right clicking the database and selecting New--View, it threw the same error messages to me.

 

 

UPDATE

The spatial column of the view is from database A, so I enabled Geodatabase for database A, but didn't enable Geodatabase for B, could this be the issue?

Outcomes