美高梅游戏官网娱乐_美高梅手机登录网站

美高梅游戏官网娱乐是公司推出的企业级即时在线娱乐平台,美高梅手机登录网站业界专业、信誉最好的博彩网站,美高梅游戏官网娱乐拥有最高优惠活动和返水,拥有丰富的管理经验和专业的技术队.。

来自 数据库 2019-10-22 15:12 的文章
当前位置: 美高梅游戏官网娱乐 > 数据库 > 正文

解决方法美高梅手机登录网站,可能需要重新新

在SQL SEEvoqueVE凯雷德 2010 Sportage2下用Windows 身份验证的记名名创造了一个寻访ORACLE数据库的链接服务器xxxxx,测量检验成功,木有有失常态态,可是任何登入名使用该链接服务器时,报如下错误:

背景:

消息 7302,级别 16,状态 1,第 1 行

     全新服务器,须要扩大质量监控,发现不能够透过powershell读取品质指标

Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server "xxxxxx".

缓和方式:

 

  • Open the Registry Editor by going to the Start Menu and selecting Run…, then type “regedit”, and click the OK button.
  • Navigate to the HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSecurePipeServerswinreg registry key.
  • Right click on the "winreg" key and select Permissions. Add users or groups to which you want to grant Read access.
  • Exit Registry Editor and restart Windows.

那儿亟需在“服务器对象”——>“链接服务器”——>“访谈接口”下,找到OraOLEDB.Oracle选项,单击右键采用属性,然后在访问接口选项下勾选“允许进度内”(Allow inprocess)。就可以消除地方难题,不常候,恐怕须要再行新建此链接服务器。

美高梅手机登录网站 1

 

鬼子给出了贰个消除这几个题指标步子,特出详细严刻,大致八面玲珑。能够看成参照他事他说加以考察学习的好材质:

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_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 “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.

  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:Click 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.

 

 

本文由美高梅游戏官网娱乐发布于数据库,转载请注明出处:解决方法美高梅手机登录网站,可能需要重新新

关键词: