sql oraoledb.oracle,无法创建链接服务器XXXXX的 OLE DB 访问接口OraOLEDB.Oracle的实例。 (Microsoft SQL Server,错误7302)...

无法创建链接服务器“XXXXX”的 OLE DB 访问接口“OraOLEDB.Oracle”的实例。 (Microsoft SQL Server，错误: 7302)

老外给出了一个解决这个问题的步骤，相当详细严谨，几乎面面俱到。可以作为参考学习的好资料： Ran into this issue where the linked server would work for users who were local admins on the server, but not for anyone else. After many hours of messing around, I managed to fix the problem using the following steps:

1：Run “dcomcnfg.exe”. Navigate to “Component Services -> Computers -> My Computer -> DCOM Config”.

2：Open the properties page of “MSDAINITIALIZE”.

3：Copy the “Application ID” on the properties page.

4：Close out of “dcomcnfg”.

5：Run “regedit”. Navigate to “HKEY_CLASSES_ROOT\AppID\{???}” with the ??? representing the application ID you copied in step #3.

6：Right click the “{???}” folder and select “Permissions”

7：Add the local administrators group to the permissions, grant them full control. 8：Close out of “regedit”.

9：Reboot the server.

10：Run “dcomconfig”. Navigate to “Component Services -> Computers -> My Computer -> DCOM Config”.

11：Open the properties page of “MSDAINITIALIZE”.

12：On the “Security” tab, select “Customize” under “Launch and Activation Permissions”, then click the “Edit” button.

13：Add “Authenticated Users” and grant them all 4 launch and activation permissions.

14：Close out of “dcomcnfg”.

15：Find the Oracle install root directory. “E:\Oracle” in my case.