SQL Server 2019 local computer install failure

Schwartz, Eric (DG-CHI) 106 Reputation points
2021-02-14T18:38:15.953+00:00

I am attempting to install a SQL 2019 server on my local computer. At the last step I receive the following error:

Error installing Microsoft ODBC Driver for SQL Server
A previous installation required a reboot of the machine for changes to take effect. To proceed, restart your computer and then run Setup again.
Error code: -2147483648

I have rebooted my computer as well as reattempted the setup process but continue to receive the same error. Does anybody know what my next troubleshooting steps should be or how to solve this issue?

SQL Server Other
0 comments No comments
{count} votes

Accepted answer
  1. Schwartz, Eric (DG-CHI) 106 Reputation points
    2021-02-14T19:15:17.133+00:00

    Thank you Erland Sommarskog! It turns out I actually had the wrong ODBC driver installed (I had 13 instead of 17) so it appears the install has worked. However, if I run into another issue later I'll be sure to check out this resource. Thanks again for the help!

    2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2021-02-14T19:09:03.617+00:00

    In the registry go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager and check the value PendingFileRenameOperations you may have something here which for some reason is never carried out. Delete or rename the key.

    A little more info here: https://community.broadcom.com/symantecenterprise/communities/community-home/librarydocuments/viewdocument?DocumentKey=6427e9b7-5658-4dcd-b201-d18b10501e85&CommunityKey=1ecf5f55-9545-44d6-b0f4-4e4a7f5f5e68&tab=librarydocuments. (And, yes, there is no mention of SQL Server in that post, as this is a more general problem on Windows level.)

    3 people found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.