I don't see anything in their connection strings that indicate they're trying to log in as a "user" vs "login" so I still have no idea what the issue is.

They are using a stored procedure at the upper level which references the views, and I'm not sure changing the last view's code to be a proc in the other...

Yes. I triple-checked before I posted.

Oh, thank you for that bit of code. I shall try it out. It might help.

Will that tell me if it's double-hopping?

I could use some perspective on an execution issue, please. Schema Execute not working on sproc – SQLServerCentral Forums.

Quick interuption: 5+ gallons of blueberries from my bushes. First picking. And oh, do they taste good.

More berries to come in a few weeks, possibly just as many.

What to do....

Is "Product Name" just a tag, then? Not actually required for the linked server to function?

Let's start off with what I think the answer was: Stop & resume data movement.

With a large 40 TB database, yes, I could see this scenario RARELY. They don't want...

I have found it difficult to use the search functions here, actually. I often find myself trying to find a post or, more likely, an article I know I read...

And when I click on an email post alert (just now did it), it took me approximately 7 pages back on this thread instead of to the post directly.

I've gotten...

I really hope the OP got the problem resolved or called in an expert. If I were the client, I'd be steaming by now if my stuff was still down....

Just to add my two cents in, I have seen a similar error many years ago with an older version of SQL and it was a certificate issue. The certificate...

Does the problem persist when using SQL Native Client instead of the OLEDB?

I've noticed the OLEDB for SQL Server in the wizard does funny things and stopped using it quite...

• This reply was modified 7 months, 3 weeks ago by  Brandie Tarvin.

This is an availability group or a clustered instance?