SQL Server Performance

Failures during install of SP on SQL Server 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by w84me2say, Nov 8, 2007.

  1. w84me2say New Member

    I've installed the SP2 on three dev/test servers. I went to install on production and the install failed on the Nofication and Client updates.
    The error message was -
    MSP Error: 29549 Failed to install and configure assemblies C:program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
    Error message: Unknown error 0x80131501
    Error description: The transaction has aborted.
    MSP Error: 29549 Failed to install and configure assemblies C:program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
    Error message: Unknown error 0x80131501
    Error description: The transaction has aborted.
    Any ideas?
  2. satya Moderator

    See this KBA http://support.microsoft.com/kb/940971 and also try:
    1. Enable MSDTC and COM+ if disabled
    MSDTC is Distributed Transaction Coordinator windows service.
    Open Computer Manager -- Services -- Distributed Transaction Coordinator

    2. Start MSDTC and COM+

    3. Re-run SQL Server SP2 install
  3. mogalappa New Member

    Hello,
    I have tried, it is not resolved from my end, can you please confirm you start COM+? MSDTC is already started with network service account.
    See the error below..
    From Hotfix log
    Copy Engine: Creating MSP install log file at: C:program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
    03/05/2008 14:04:13.918 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
    03/05/2008 14:04:13.978 Registry: Cannot read registry key value "Debug"
    03/05/2008 14:09:39.117 MSP Error: 29549 Failed to install and configure assemblies
    c:program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll
    in the COM+ catalog. Error: -2147024894
    Error message: The system cannot find the file specified.
    Error
    description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral,
    PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
    03/05/2008 14:11:23.394 MSP returned 1603: A fatal error occurred during installation.
    03/05/2008 14:11:23.724 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
    03/05/2008 14:11:23.765 Registry: Cannot read registry key value "Debug"
    03/05/2008 14:11:24.476 Copy Engine: Error, unable to install MSP file: c:d6bc5fe34e51a4a049cb757d6e04acHotFixToolsFilessqlrun_tools.msp
    03/05/2008 14:11:24.526 The following exception occurred: Unable to install Windows Installer MSP file Date: 03/05/2008 14:11:24.526
    File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 800
    From service pack log..Log Location: C:program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
    MSP Error: 29549 Failed to install and configure assemblies c:program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894
    Error message: The system cannot find the file specified.
    Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

Share This Page