SQL 2008連Oracle Linked Server出現Access denied

在SQL 2008 x64 @ Win 2008 R2 x64上使用Linked Server連上Oracle，進行查詢時傳回以下錯誤:

select * from openquery(OraServerA, ‘select sysdate from dual’)

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "OraServerA" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "OraOLEDB.Oracle" for linked server "OraServerA".

之前用SQL連Oracle Linked Server的做法應用在很多地方過，沒遇到這種問題，不知是否是因為x64的關係，爬文後發現機關一處:

記得設定Allow Inprocess後要重新建立Linked Server才會生效!