nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Server - error using views

PeterBaldwin

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,

Peter.

Find more posts tagged with

Accepted answers

All comments

PeterBaldwin

It works okay with one of our Database Authenticated login.

Thanks,

Peter.

AsrujitSengupta

Can you give it a try with any Database Authenticated login and check what happens.

PeterBaldwin

Hi Asrujit,

Thanks for your reply.

I'm able to preview the View in SSMS okay. In ArcCatalog I'm using an OS Authenticated connection.

Thanks,

Peter.

AsrujitSengupta

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.