I am trying to access data through linked server by following query
select * from [Servername].dbname.schema.view_name
and my schema is not dbo.
When I tried this with sa login it is giving me correct output,
but when I tried to access data through login from which linked server is configured it is giving me login failed for user error.
I have already maped database to login with it default schema.
please help me out....