《无法创建链接服务器XXXXX的OLEDB访问接口OraOLEDBOracle的实例。(MicrosoftSQLServer,错误7302)》由会员分享,可在线阅读,更多相关《无法创建链接服务器XXXXX的OLEDB访问接口OraOLEDBOracle的实例。(MicrosoftSQLServer,错误7302)(2页珍藏版)》请在金锄头文库上搜索。
1、无法创建链接服务器“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。
2、 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_。
3、CLASSES_ROOTAppID?” 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 “Co。
4、mponent 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 permi。
5、ssions.14:Close out of “dcomcnfg”.15:Find the Oracle install root directory. “E:Oracle” in my case.16:Edit the security properties of the Oracle root directory. Add “Authenticated Users” and grant them “Read & Execute”, “List folder contents” and “Read” permissions. Apply the new permissions.17:Clic。
6、k the “Advanced Permissions” button, then click “Change Permissions”. Select “Replace all child object permissions with inheritable permissions from this object”. Apply the new permissions.18:Find the “OraOLEDB.Oracle” provider in SQL Server. Make sure the “Allow Inprocess” parameter is checked.19:Reboot the server.。