server性能计数器问题

图片 1

server性能计数器问题

在SQL SEEscortVEXC90 2009 揽胜2下用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.

server性能计数器问题。  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.

 

 

admin

网站地图xml地图