none
SQL Instance names missing

    Question

  • Trying to uninstall a SQL 2008 R2 cluster instance from a production two node Windows Server 2008 R2 SQL cluster.  I'm using the SQL installation CD, selecting "Remove node from a SQL Server failover cluster" under Maintenance.  Performed on the passive node first and I received a blank list to choose from as shown in attached screen shot.  I then failed the instance over to try from the other Window cluster node, however I achieved the same results.  Any ideas?  I have 8 SQL Clustered instance running on these two nodes.  Thanks in Advance

    Thursday, December 29, 2016 6:36 PM

Answers

  • - Was this installation of SQL Server successful?

    - Are your user a Local Admin on the server?

    - Do you run the Setup "run as an administrator"?

    These are the only things I can think of for now.

    Also, 8 clustered instance on two nodes is really surprising and interesting. 


    http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy

    • Marked as answer by mgtow Tuesday, January 3, 2017 5:50 PM
    Thursday, December 29, 2016 7:08 PM

All replies

  • - Was this installation of SQL Server successful?

    - Are your user a Local Admin on the server?

    - Do you run the Setup "run as an administrator"?

    These are the only things I can think of for now.

    Also, 8 clustered instance on two nodes is really surprising and interesting. 


    http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy

    • Marked as answer by mgtow Tuesday, January 3, 2017 5:50 PM
    Thursday, December 29, 2016 7:08 PM
  • cmd >SQLCMD -L

    share result and also check control panel and services.msc where sql related services are present.

    refer following link

    https://sqlactions.com/2012/12/29/sql-server-2008-r2-cluster-instance-missing-post-uninstallation-of-other-instance/


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.


    • Edited by Av111 Thursday, December 29, 2016 7:13 PM link
    Thursday, December 29, 2016 7:10 PM
  • You likely ran setup.exe from the wrong media.  Setup only recognizes the version it is.  You cannot run Setup from SQL 2008 for SQL 2008 R2 instances.

    Thursday, December 29, 2016 8:20 PM
  • To successfully uninstall my SQL Clusters, I had to do three things:  Run setup as Administrator, make sure the remote registry and wmi services were started.  Thanks for everyone's input
    Tuesday, January 3, 2017 5:53 PM