Unable to Uninstall SQL Server 2005 Reporting services & Notification Services

  • Hi,

    We have A/A/P cluster setup for SQL Server 2005. On Node3 (Active), Reporting Services and Notification services were installed long back and those features does NOT exist on Node1(Acitve). Node2 is passive.

    We want to perform in-place upgrade to SQL Server 2008. But according to Upgrade document, we should have same features installed on all nodes to perform in-place upgrade and we are never used Reporting Services & Notification Services that were installed on node3.

    Now, I trying to uninstall both Reporting Services and Notification Services from Node3 (By going to Add/remove programs->Microsoft SQL Server 2005->Change->Remove), But I'm getting the uninstalled is failed and the below error is logged in log files

    Failed to grab execution mutex. System error 258

    Please advice me how can I successfully uninstall Reporting Services & Notification Services..

    Many thanks

  • More details:

    SQLSetup0018_SQL3_Core(Local).log

    From the above log file, It's reports that there is another installation is already in progress!! But that NOT the case..for the first time I'm trying to uninstall and I'm sure that there is only one uninstallation running. Why the log is saying that there is another installation is running? please advice..It's production server and I need to uninstall reporting services & notification services before plan to perform in-place upgrade to SQL Server 2008..

    Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:

    Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:

    Condition "The Clustered SQL Server instance that hosts is installed." returned false.

    Running: ReportChainingResults at: 2010/5/5 16:44:55

    Error: Action "ReportChainingResults" threw an exception during execution.

    One or more packages failed to install. Refer to logs for error details. : 1618

    Error Code: 0x80070652 (1618)

    Windows Error Text: Another installation is already in progress. Complete that installation before proceeding with this install.

    Source File Name: sqlchaining\sqlchainingactions.cpp

    Compiler Timestamp: Mon Nov 17 17:06:19 2008

    Function Name: sqls::ReportChainingResults::perform

    Source Line Number: 3521

    Thanks

  • I appreciate your help..I'm NOT getting any clue why the uninstall of Reporting Services & Notification Services is failing??

    thanks

  • Was this resolved?

  • Was this resolved?

    Hi Manu,

    It's NOT resolved yet..do you have any advice to resolve the issue?

    Thanks

  • could you please advice me..

    Thanks

  • I'm still facing the same issue and I did NOT understand why we required SQL Server software CD to uninstall SQL Server features (some one suggested me to put the SQL Server software CD & do the uninstall. I did NOT understand so far how to do that as I'm always getting the new install wizard only & I did not see any wizard asking to install any features)

    Please advice me what are the option further I can try?

    My goal is to uninstall Notification services & Reporting services from node1 (which were installed unnecessary and I want to have same features installed on all nodes so that in-place upgrade to SQL Server 2008 will NOT have issues )

    Thanks

  • This time I tried the uninstall after rebooting all the nodes and it's worked!!!

    I did not understand what the reason but it worked

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply