Cannot add a View from SQL Server to Arcmap

464
1
06-28-2020 11:53 PM
ZacWang
New Contributor II

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?

0 Kudos
1 Reply
ZacWang
New Contributor II

Let me answer the question myself.

The cause of this issue is that the database account I used doesn't have access to one of the databases.

So the solution is also straightforward. Use a suitable account.

Basically, ArcGIS should provide a more useful error message.

0 Kudos