Error Message: You don't have permission to view this data. Server Response: Failed. Credentials are missing or not valid.
I'm breaking my teeth on this one. I get it every single time when I make a connection to SQL server and call an view created from tables from SLQ Linked Server (The connection works fine for both views and tables from directly referenced SQL Server.). Sometimes it randomly start working next day sometimes I have to build new connection to make it work other times it doesn't work.