Unable to remove SQL server instance name completely

Question

I have uninstalled SQL server failover cluster along with SQL instance. When i try to install SQL server 2008 r2 failover cluster, setup is failing due to instance name already exists. I have removed the instance computer object from AD. Still getting the same issue.

Can anyone guide me how to remove the instance completely and install new sql server with same instance name

Regards,

Jimat

Answer 1

First thing to do is use discovery report and check if it reports any instance. If yes, then perform "RemoveNode" operation using SQL Server Installation center

---

Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter

Answer 2

This is the error what we are getting. I have removed the computer object also from AD. Still i'm unable to add the old instance name..

Please help..

Answer 3

If you can come online on MSN, I can guide you. blakhani (at) Koolmail (dot) in

---

Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter

Answer 4

Our enviroment has some restrictions to use e-mail\chat..

I have removed the node n uninstalled the sql server 2008 r2.

Even i tried the below command after uninstallation.

setup.exe /ACTION=uninstall /FEATURES=SQL,AS,BOL,SSMS /INSTANCENAME=MSSQLSERVER

Then i removed th computer object from AD.

i'm going for a fresh installation now. i need the use same sql instance name but no luck..

Did i miss anything while uninstallation??

Answer 5

Do we need to reset the DNS entry ?

Answer 6

SQL server 2008 R2 installation is not going forward after Setup Support files. Installation .exe is getting exited automatically.
 
Anyone experienced the same problem before?
 
is it the problem with registry corruption or anything else?
 
I tried installing through GUI as well as command prompt but no luck.
 
Followed process
-------------------

I have removed the node and uninstalled the sql server today morning. When i tried to install again, it got failed saying the same instance name is already exists.
 
I had removed the DNS entry as well as computer object in ADS.
 
Now the installation itself not proceeding :(.

Answer 7

1. Restart your PC.
2. After Setup Support Files completes, you may have to wait for a while.
3. If it doesn't continue, then it may be a problem with your media.

This also may help you: SQL 2008/2008 R2/2012 setup disappears/fails when installing Setup Support files

Answer 8

Hello,

Is .NET Framework 3.5 enabled? Please go to Control Panel -> Programs and Features -> Turn on/off.

Please run the discovery report using the instructions provided on the following post:

http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx  

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 9

Uninstall setup support files from control panel and then log off from the server and login back and then attempt the installation again.

Answer 10

CLUSTER RES "SQL Network Name (Instance name)" /DELETE

Issue fixed ..