fatal error during installation (0x80070643) SQL Server MAnagement Studio: A valid destination folder for the install could not be determined

sql-server sql-server-2008 smss
Fzn picture Fzn · Sep 23, 2017 · Viewed 17.9k times · Source

I am installing the Microsoft SQL Server Management Studio (17.2).

It was installed before, but I re-install it because I forgot the admin password (shouldn't do this actually).

However, the re-installation is not successful. The same error message occurs:

fatal error during installation (0x80070643) SQL Server MAnagement Studio: A valid destination folder for the install could not be determined

I've found one solution here

A valid destination folder for the install could not be determined when installing SQL Server Management Studio 2016

But it didn't work on my machine. I even couldn't find the BootstrapDir.

Any ideas what I might look for to solve this problem?

Thanks.

Answer

atomicicebreaker picture atomicicebreaker · Aug 10, 2020

Sorry for digging up this grave. If anyone has the same problem there is one registry key that blocks the instalation. Copying from this article. https://help.act.com/hc/en-us/articles/360024248314-Error-A-computer-restart-is-required-or-Reboot-pending-When-Attempting-to-Install-Act-or-the-Microsoft-SQL-Server-ACT7-Instance HKEY_LOCAL_MACHINE\SYSTEM\ControlSet\Control\Session Manager\PendingFileRenameOperations HKEY_LOCAL_MACHINE\SYSTEM\ControlSet[00n]\Control\Session Manager\PendingFileRenameOperations. This key can be a leftover sometimes and it signals the installer that there is a reboot pending after some other instalation. After deleting it installation goes without any problems.

Related questions

How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More
How to check if a column exists in a SQL Server table?

I need to add a specific column if it does not exist. I have something like the following, but it always returns false: IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'myTableName' AND COLUMN_NAME = 'myColumnName') How can …

Read More