To alow darta access through linked server using OPENQUERY we need to set set linked server "DATA ACCESS" option to true:
EXEC sp_serveroption 'YourServer', 'DATA ACCESS', TRUE
Use this option when you get following error message:
Msg 7411, Level 16, State 1, Line 1
Server 'MYSERVER' is not configured for DATA ACCESS.