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.
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?