新葡亰496net 新葡亰496net transaction manager has disabled its support for remote/network transactions. 该伙伴事务管理器已经禁止了它对远程/网络事务的支持

transaction manager has disabled its support for remote/network transactions. 该伙伴事务管理器已经禁止了它对远程/网络事务的支持



  8:Close out of “regedit”.

最后找到解决方案:

     全新服务器,需要增加性能监控,发现无法通过powershell读取性能指标

  9:Reboot the server.

                      
新葡亰496net 1

  • Open the Registry Editor by going to the Start Menu and selecting
    Run…, then type “regedit”, and click the OK button.
  • 新葡亰496net,Navigate to the
    HKEY_LOCAL_MACHINE澳门葡亰娱乐场手机版,SYSTEMCurrentControlSetControlSecurePipeServerswinreg 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.

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

  1. Go to Start -> Run. Type in DCOMCNFG.
  2. Go to the properties of the My Computer node under
    the Computers folder underneath Component Services.
  3. Under the My Computer Properties look under the
    Default Protocols tab.
  4. Over there make sure that Connection-oriented TCP/IP
    is selected and then click on Properties.
  5. You will see a window like this
                           
    新葡亰496net 2

解决方法:

 

3.在事务中,即使存在嵌套的情况,同一个事务内的所有数据库连接对数据都是可访问的。

背景:

  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.

ps:

  11:Open the properties page of
“MSDAINITIALIZE”.

新葡亰496net 3

在SQL SERVER 2008 R2下用Windows
身份认证的登录名创建了一个访问ORACLE数据库的链接服务器xxxxx,测试成功,木有问题,但是其它登录名使用该链接服务器时,报如下错误:

HKEY_LOCAL_MACHINESOFTWAREPoliciesMicrosoftWindows NT

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

RESTRICTING THE
DCOM PORT RANGE

  14:Close out of “dcomcnfg”.

2.需要打开分布式的端口,端口号是135,或者添加System32下msdtc.exe的例外(netsh firewall set
allowedprogram %windir%/system32/msdtc.exe MSDTC
enable )。

标签:

相关文章

发表评论

电子邮件地址不会被公开。 必填项已用*标注

网站地图xml地图