SQL instances still remain after uninstalling

Alvaro_Arancibia_P 1

Hi,
I carried out the uninstallation of SQL server on my computer including the instances. When I reinstall SQL server they keep appearing. How can I permanently remove them to reuse the default instance name?

Thanks in advance

Shashank Singh 6,246 Reputation points

2021-03-12T13:08:44.543+00:00

You must have not uninstalled the SQL Server instance correctly. How did you remove it ?
Alvaro_Arancibia_P 1 Reputation point

2021-03-12T13:17:14.02+00:00

I have followed the steps indicated in the post whose link I share below:

https://learn.microsoft.com/en-us/sql/sql-server/install/uninstall-an-existing-instance-of-sql-server-setup?view=sql-server-ver15&tabs=Windows10

Regards
Shashank Singh 6,246 Reputation points

2021-03-12T13:23:13.983+00:00

Are you uninstalling the DB engine services also ? Can you post summary file generated post uninstall. This link should help you locate it. Look for the date when you uninstalled the file, Post content of that file.
Alvaro_Arancibia_P 1 Reputation point

2021-03-12T13:39:21.107+00:00

Shashank, thanks for your help

I'll do what you suggested.

On the other hand, I am having trouble installing SQL Server 2019, this is the error message:

TITLE: Microsoft SQL Server 2019 Setup

The following error has occurred:

The folder 'C:\Users\alvar\Downloads\SQL2019[DirSharedForCurrentVersion]' does not exist. The folder is expected to exist to set permission on it.

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0x27731616%25400x735014D4%25401231%25401

BUTTONS:

&Retry
Cancel

Is there any utility to repair the SQL server registry or lost directories?

Regards
Shashank Singh 6,246 Reputation points

2021-03-12T14:15:34.543+00:00

May i suggest you to open new thread for this new issue, I will have a look and also, because of new thread, it will get more visibility.
Alvaro_Arancibia_P 1 Reputation point

2021-03-12T15:01:13.273+00:00

Shashank,

Summary.txt file is attached, cannot be posted as a response because the text exceeds 1000 characters

77272-summary.txt
CarrinWu-MSFT 6,851 Reputation points

2021-03-15T03:08:22.273+00:00

Hi @Alvaro_Arancibia_P , are you trying to remove the 2 instances? or you would like to uninstall SQL server? If you are preparing to remove both of instances, I suggest that you can uninstall SQL server, and then reinstall a new SQL Server.
CarrinWu-MSFT 6,851 Reputation points

2021-03-16T05:14:58.22+00:00

Hi @Alvaro_Arancibia_P , any update for this issue?
Alvaro_Arancibia_P 1 Reputation point

2021-03-16T12:29:56.79+00:00

I followed the instructions in this link, and after cleaning the SQL server registry and changing the folder names, I tried to install a new instance. The following error message appeared during installation.

2 answers

CarrinWu-MSFT 6,851 Reputation points

2021-03-17T02:22:39.267+00:00
Hi @Alvaro_Arancibia_P ,

Have you run setup.exe as administrator? The error code: 0x84BB0001 occurs under the following scenarios, so please make sure there have enough permissions to install SQL Server. You could get more details from this link.

Remnants of previous failed SQL Server installations still exist on your computer.

SQL Server installation is corrupted, you may need to download the SQL Server media again, and try install SQL Server again.

The user did not have the permissions to access the register, you can grant full permissions to below registry keys to the setup account and SQL Service account.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\120\

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Alvaro_Arancibia_P 1 Reputation point

2021-03-17T12:42:33.583+00:00

Hi @Carrin-msft
I ran setup.exe as administrator, tried to install a new instance but another error message appears during installation:

CarrinWu-MSFT 6,851 Reputation points

2021-03-18T01:24:48.957+00:00

Could you please check the setup error log details to get more information about your issues? Please chose the latest one, not same as me, see below:

Alvaro_Arancibia_P 1 Reputation point

2021-03-18T11:24:35.39+00:00

Sure here it is
79168-detail.txt
Sign in to comment
Anonymous

2022-11-24T00:53:23.03+00:00

I find that Services are still listed in services.msc after removal. Of course they cannot be started. The only real solution seems to be a ground up re-install of the platform without MSSQLServer.

In addition, upon a re-install we are presented with "One or more SQL Server 2019 CTP 3.x instances detected. To install a second instance, click Accept. To perform and in-place upgrade to the new CTP, click Previous, then Custom."

So nuking from orbit seems the only way.
Please sign in to rate this answer.
Vishal Pawar 0 Reputation points

2023-04-20T11:04:43.87+00:00

Hello Matthew, Please delete the Key related to your instance remove the key HKEY_LOCAL_MACHINE>Software>Microsoft>Microsoft SQL Server. For 64 bit and try to install the setup again and then you will not see the second entry there
Sign in to comment