While running the following query distributed query select * from openrowset ('OraOLEDB.Oracle','oradb';'scott';'pwd1234$', 'select * from emp') I got the following error message : Msg 15281, Level 16, State 1, Line 1 SQL Server blocked access to STATEMENT