sqlserver 2005 安装三折之二

来源：互联网发布：淘宝我的快递历史删除编辑：程序博客网时间：2024/05/16 00:32

问题：无法在 COM+ 目录中安装和配置程序集 microsoft.sqlserver.notificationservices.dll

          Summary.txt（Summary.txt 位于%ProgramFiles%/Program Files/Microsoft SQL Server/90/Setup Bootstrap/LOG/Hotfix）文件中有如下信息。
          Machine : ServerName
          Product : Client Components
          Error : Failed to install and configure assemblies C:/Program Files/Microsoft SQL Server/90/NotificationServices/9.0.242     /Bin/microsoft.sqlserver.notificationservices.dll in the COM+ catalog.
          Error: -2146233087
          Error message: Unknown error 0x80131501
          Error description: The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B)

微软提供的解决办法如下：
To work around this problem, make sure that the Distributed Transaction Coordinator service runs under the NT AUTHORITY/NetworkService account. To do this, follow these steps:1. Click Start, click Run, type Services.msc, and then click OK.
2. In the Services window, double-click the Distributed Transaction Coordinator service.
3. In the Distributed Transaction Coordinator Properties dialog box, click the Log On tab.
4. On the Log On tab, specify the NT AUTHORITY/NetworkService account to be the logon account if the logon account is not the NT AUTHORITY/NetworkService account.

Note You are prompted to restart the Distributed Transaction Coordinator service if the following conditions are true:• You change the logon account of the Distributed Transaction Coordinator service.
• The Distributed Transaction Coordinator service is running before you change the logon account.

5. Start the Distributed Transaction Coordinator service if it is not started.

但是在启动时如果出错，错误代码为1073337669 的话，在命令提示符里输入
msdtc -resetlog

注:这种错误我只有在安装VS2005时不选择SQL Server组件，后来再安装SQL Server时才出现。