We've created a view in SQL Server Management Studio but are getting an error message when viewing in ArcCatalog:
The only thing unusual about the view query is that it is joining data from a Linked Server. We don't think it is a permissions issue as the user has permissions to display data from the main table and from the table reference via the Linked Server.
Thanks for any help,
Are you able to preview the View in SQL Server Management Studio?
What kind of login is being used to create the View and preview in ArcMap (Database Authenticated or Windows Authenticated?
Actually, when I try to do it in SSMS with Windows authentication using my user login I get this SQL error message:
Login failed for user 'NT AUTHORITY\ANONYMOUSE LOGON'.
Previously in SSMS I have been connecting with an admin user, which was working fine.