安裝SQL Server 2005的時候，出現錯誤，錯誤對話框的內容沒有記錄下來，不過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.
