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?
Thanks for your reply.
I'm able to preview the View in SSMS okay. In ArcCatalog I'm using an OS Authenticated connection.
Can you give it a try with any Database Authenticated login and check what happens.
It works okay with one of our Database Authenticated login.
Sorry for asking this again, but were you able to preview that same View in SQL Server Management Studio when connected with your Windows Authenticated login?
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.
That is of course ANONYMOUS