none
can't uninstall a named instance on SQL Server 2008 R2

    Question

  • I am trying to uninstall a single SQL Server named instance on a machine that apparently has too many of them.  When I try to uninstall I get the following error
    cd C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release
    Setup.exe /Action=Uninstall /Q /FEATURES=SQL /INSTANCENAME=BANDOL
    Overall summary:
      Final result:                  Échec : voir les détails ci-dessous
      Exit code (Decimal):           2064843076
      Exit facility code:            787
      Exit error code:               324
      Exit message:                  SQL Server 2008 ne peut plus ajouter d'instances. Pour continuer l'installation de cette instance, vous devez désinstaller une instance existante.
      Start time:                    2011-08-30 17:02:48
      End time:                      2011-08-30 17:03:16
      Requested action:              Uninstall
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110830_170213\Detail.txt
      Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.2531.0%26EvtType%3d0xE9BC3D64
    Which basically means that even though I am trying to uninstall the instance, SQL Server setup thinks I'm trying to add one.


    • Changed type CraigEfrein Friday, September 16, 2011 1:10 PM Question is still unanswered
    • Edited by CraigEfrein Friday, September 16, 2011 1:11 PM
    Tuesday, August 30, 2011 3:33 PM

All replies

  • Hi CraigEfrein,

    Please check if you uninstalled the named instance on SQL Server 2008 R2 in a proper way.
    Here is a kb article about how to uninstall an instance of SQL Server 2008:
    http://support.microsoft.com/kb/955499

    For further investigate, could you please post the error log which is in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110830_170213\Detail.txt?


    Hopes this helps.


    Best Regards, Maggie. Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Thursday, September 01, 2011 6:45 AM
  • Hello Maggie,

    Thank you for getting back to me.

    Here is what I found in Detail.txt

     

     

    2011-08-30 17:03:13 Slp: QueryDiscoveryForTransforms: No more transforms are available because the maximum 50 has been reached.
    2011-08-30 17:03:13 Slp: Error: Action "SetMultiInstanceTransformAction" threw an exception during execution.
    2011-08-30 17:03:13 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: SQL Server 2008 ne peut plus ajouter d'instances. Pour continuer l'installation de cette instance, vous devez désinstaller une instance existante. ---> System.InvalidOperationException: SQL Server 2008 ne peut plus ajouter d'instances. Pour continuer l'installation de cette instance, vous devez désinstaller une instance existante.
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Configuration.SetupExtension.QueryPackageTransforms.QueryDiscoveryForTransforms(PackageAttribute pkgAttr, String instanceName, List`1 siblingGroup, PackageTransforms& packageTransforms)
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Configuration.SetupExtension.SetMultiInstanceTransformAction.ExecuteAction(String actionId)
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2011-08-30 17:03:13 Slp:  --- Fin de la trace de la pile d'exception interne ---
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
    2011-08-30 17:03:13 Slp: Error: Action "ExecuteUninstallCalculateWorkflow" threw an exception during execution.
    2011-08-30 17:03:13 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: SQL Server 2008 ne peut plus ajouter d'instances. Pour continuer l'installation de cette instance, vous devez désinstaller une instance existante. ---> System.InvalidOperationException: SQL Server 2008 ne peut plus ajouter d'instances. Pour continuer l'installation de cette instance, vous devez désinstaller une instance existante.
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Configuration.SetupExtension.QueryPackageTransforms.QueryDiscoveryForTransforms(PackageAttribute pkgAttr, String instanceName, List`1 siblingGroup, PackageTransforms& packageTransforms)
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Configuration.SetupExtension.SetMultiInstanceTransformAction.ExecuteAction(String actionId)
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2011-08-30 17:03:13 Slp:  --- Fin de la trace de la pile d'exception interne ---
    2011-08-30 17:03:13 Slp:  à Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
    2011-08-30 17:03:14 Slp: Received request to add the following file to Watson reporting: C:\Users\Administrateur\AppData\Local\Temp\5\tmp8A4F.tmp
    2011-08-30 17:03:14 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
    2011-08-30 17:03:14 Slp: Inner exceptions are being indented
    2011-08-30 17:03:14 Slp: 
    2011-08-30 17:03:14 Slp: Exception type: System.InvalidOperationException
    2011-08-30 17:03:14 Slp:   Message: 
    2011-08-30 17:03:14 Slp:     SQL Server 2008 ne peut plus ajouter d'instances. Pour continuer l'installation de cette instance, vous devez désinstaller une instance existante.
    

    2011-08-30 17:03:14 Slp: Parameter 0 : SQL2008@RTM@ 
    
    2011-08-30 17:03:14 Slp: Parameter 3 : 0xE9BC3D64 
    
    2011-08-30 17:03:14 Slp: Parameter 4 : 0xE9BC3D64 
    
    2011-08-30 17:03:14 Slp: Parameter 5 : ExecuteUninstallCalculateWorkflow 
    
    2011-08-30 17:03:14 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110830_170213\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
    2011-08-30 17:03:15 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110830_170213\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2011-08-30 17:03:15 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110830_170213\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
    2011-08-30 17:03:15 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110830_170213\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
    2011-08-30 17:03:15 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110830_170213\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
    2011-08-30 17:03:15 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110830_170213\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
    2011-08-30 17:03:16 Slp: SQL Server 2008 ne peut plus ajouter d'instances. Pour continuer l'installation de cette instance, vous devez désinstaller une instance existante.
    2011-08-30 17:03:16 Slp: Watson bucket for exception based failure has been created
    2011-08-30 17:03:16 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine 
    2011-08-30 17:03:16 Slp: Sco: Attempting to open registry subkey 
    2011-08-30 17:03:16 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
    2011-08-30 17:03:16 Slp: Sco: Attempting to get registry value DW0201
    2011-08-30 17:03:16 Slp: Submitted 1 of 1 failures to the Watson data repository
    2011-08-30 17:03:18 Slp: 
    2011-08-30 17:03:18 Slp: ----------------------------------------------------------------------
    2011-08-30 17:03:18 Slp: 
    2011-08-30 17:03:18 Slp: Error result: 2064843076
    2011-08-30 17:03:18 Slp: Result facility code: 787
    2011-08-30 17:03:18 Slp: Result error code: 324
    
    Any thoughts, I am still unable to uninstall any of the named instances.    Does it help to mention that we have reached the maximum number of instances possible?

     


    Thursday, September 01, 2011 10:28 AM
  • Hi CraigEfrein,


    You could try to use below method to uninstall a named instance on SQL Server 2008 R2:

    1. To begin the uninstall process, from the Start menu, click Control Panel, and then double-click Add or Remove Programs.
    2. Select the SQL Server component to uninstall, and then click Change/Remove. This starts the SQL Server Installation Wizard.
    3. Setup Support Rules runs to verify your computer configuration. To continue, click OK.
    4. On the Select Instance page, use the drop-down box to specify an instance of SQL Server to remove, or specify the option to remove only the SQL Server shared features and management tools. To continue, click Next.
    5. On the Select Features page, specify the features to remove from the specified instance of SQL Server.
    6. Removal rules runs to verify that the operation can complete successfully. If Setup detects SQL Server 2008 on this machine, you will see a warning. Uninstalling shared components could render the SQL Server 2008 instance unusable.
    7. On the Ready to Uninstall page, review the list of components and features that will be uninstalled.
    8. The Setup Progress page displays Setup status.
    9. On the Completing Setup page, click Close to exit the Installation Wizard.
    10. Repeat steps 2-9 until all SQL Server 2008 R2 components have been removed.

     

     

    Hope this helps.

    Maggie


    Best Regards,  Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Friday, September 02, 2011 8:04 AM
  • Hi Craig, are all 50 instances on the machine running SQL Server 2008 R2?  Any other versions perhaps? 

     

    Thanks,
    Sam Lester (MSFT)


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, September 02, 2011 7:19 PM
  • Hello Sam,

    Yes some instances (5) are still running, but most are shutdown.   The machine has enough, ram, disk space and cpu to do whatever.   I think this is just a weird bug.   

    I already tried to uninstall via Add/Remove programs using the uninstall wizard and I don't get past the Select Features part.  The screen just hangs.   That's why I moved onto using the command line features, which is how I managed to get the Details and Summary text files. 

     

    This is the message that I believe is at the origin of the error

     

    From details.txt

    2011-08-30 17:03:13 Slp: QueryDiscoveryForTransforms: No more transforms are available because the maximum 50 has been reached.

    Monday, September 05, 2011 8:51 AM
  • Hi Maggie,

     

    Thank you again for getting back to me.  I already tried uninstalling one of the instances using the Add/Remove programs method.   The Wizard just hangs after the select features screen.   This is why I went on to the command line method.   

    I think the most revealing message from details.txt is this

    2011-08-30 17:03:13 Slp: QueryDiscoveryForTransforms: No more transforms are available because the maximum 50 has been reached.


     

    Monday, September 05, 2011 9:37 AM
  • Hi CraigEfrein,

    For further investigation on this issue, I would recommend you open a support incident with Microsoft Customer Services & Support. Please visit the below link to see the various paid support options that are available to better meet your needs.

    http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

     

     

    Thanks,

    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Tuesday, September 06, 2011 3:31 AM
  • Hi again Maggie,

    Thanks for the link, I have informed the client who now has to decide if its really worth it or not.   Seems kinda silly though, asking the client to pay for what appears to be just a bug in the uninstall process.  

    Tuesday, September 06, 2011 9:02 AM
  • Hi Craig, it does sound like a strange bug perhaps where uninstall is checking the max instance count.  Sorry to repeat the same question, but are all 50 instances at the SQL Server 2008 R2 version?  Or are there any lower versions of SQL Server (2005 perhaps) on the machine? 

    Thanks,
    Sam Lester (MSFT)


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, September 06, 2011 10:48 PM
  • I think there are several different versions.  Compact, Express and Standard.  Do you think it will be necessary to uninstall the compact and express versions?

    In Add/Remove Programs I'm seeing the following

    SQL Server Compact 3.5 SP2 FRA

    SQL Server 2008 R2 64bits

    There is an instance called SQL4\SQLEXPRESS, but I don't know if its a real express version or just a standard with an instance called express

    • Edited by CraigEfrein Tuesday, September 13, 2011 11:47 AM
    Tuesday, September 13, 2011 11:38 AM
  • Hi, did you find a solution? I am having the same issue (Slp: QueryDiscoveryForTransforms: No more transforms are available because the maximum 50 has been reached). Thanks.
    Friday, March 09, 2012 10:28 PM
  • Hello,

    I`m facing the same issue, 50 instances on SQL 2008 R2 testing server and canot uninstall any named instance.

    Thanks.

    G...

    • Proposed as answer by urvishah Friday, July 19, 2013 1:04 PM
    • Unproposed as answer by urvishah Friday, July 19, 2013 1:04 PM
    Monday, March 12, 2012 4:50 PM
  • I raised a support call with Microsoft over this. I had tried to install a new SQL 2008 R2 Enterprise instance, but I received the message that I had reached the instance limit. When trying to remove an instance to free up space it froze at "Please Wait...", in the detail.txt it gave the error that the maximum instances had been reached.

    To solve the problem, the Microsoft Technician got me to use the original installation media and run the command line uninstall command

    Setup.exe /Action=Uninstall /FEATURES=SQL,AS,RS /INSTANCENAME=MyInstance

    You can find the feature parameters here for your instance:

    http://msdn.microsoft.com/en-us/library/ms144259(v=sql.100).aspx#Feature

    This solved the problem. The MS techie said the issue was the sql setup itself uses up an instance, the command line route gets round this.


    • Proposed as answer by urvishah Friday, July 19, 2013 1:42 PM
    • Edited by urvishah Friday, July 19, 2013 1:43 PM typo
    Friday, July 19, 2013 1:41 PM