Problem repairing SQL Server 2019

Question

Problem repairing SQL Server 2019

Jaime Stuardo 71

Hello, I have installed SQL Server 2019 express with no problems.

Suddenly, SQL Server engine service did not start, so I use the setup again to repair it. When repairing, an error telling that Visual C++ 2017 redistributables are missing. This is the first strange thing, because those redistributables are present.

Well, I have used the link to install vc_redist.x64.exe. After that, I rebooted the PC and try again, but the same error occurs. Also, VSS service could not start and I don't know why.

This is some detail registered in the installation log file:

Detailed results:
Feature: Database Engine Services
Status: Failed
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, and then try the setup process again.
Component name: Microsoft ODBC Driver for SQL Server
Component error code: 1723
Component log file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220424_205126\msodbcsql_Cpu64_1.log
Error description: Please install the Visual C++ 2017 Redistributable from https://aka.ms/vs/15/release/vc_redist.x64.exe before running this installer.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=msodbcsql.msi%40Sqlmsirc_NotifyFeatureStates_64%401723

Feature: SQL Browser
Status: Passed

Feature: SQL Writer
Status: Failed
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, and then try the setup process again.
Component name: SQL Server Writer Component
Component error code: 1920
Component log file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220424_205126\SqlWriter_Cpu64_1.log
Error description: Service 'SQL Server VSS Writer' (SQLWriter) failed to start. Verify that you have sufficient privileges to start system services.
Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=SqlWriter.msi%40StartServices%401920

Feature: SQL Client Connectivity SDK
Status: Passed

Feature: SQL Client Connectivity
Status: Passed

Feature: Setup Support Files
Status: Passed

Both errors are nonsense. First one tells about the redistributables, which I have. Second one tells about the pivileges, which I have since is the only user, and even, when setup is launched, it runs as administrator.

How can I solve this?

Thanks
Jaime

Jason Westrupp 0 Reputation points

2023-08-07T00:29:53.95+00:00

I had the same issue. In the end, I grabbed the new redistributable at https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170 and installed both the x32 and x64 versions because I wasn't sure which it was looking for. A reboot and another repair later and it's back and working.

3 answers

Your answer

Jason Westrupp 0 Reputation points

2023-08-07T00:29:53.95+00:00

I had the same issue. In the end, I grabbed the new redistributable at https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170 and installed both the x32 and x64 versions because I wasn't sure which it was looking for. A reboot and another repair later and it's back and working.

Answer 1

CathyJi-MSFT 22,396 Microsoft External Staff

Hi anonymous usertuardo-5606,

When your SQL server express be installed successfully, but SQL server engine service failed to start. Please check your SQL server error log, you may find the failed reason.

Which service account that your SQL server engine service running under? Suggest you using local system account or admin account to run SQL server engine service.

Did you try to download a new express package from this MS link, then reinstall SQL server 2019 Express if your SQL 2019 express instance is new instance?

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Jaime Stuardo 71 Reputation points

2022-04-25T11:24:02.957+00:00

Hello @CathyJi-MSFT .... after I installed SQL Server 2019, it worked. When it was installed, it created a special account in order to run the service.

Then I have uninstalled all Windows 10 default programs because this is a Tablet PC intended for unattended use, so I need to free some unuseful space. One of the uninstalled application was Office 365. I suspect office 365 removed some DLL needed by SQL Server however I am wondering why SQL Server repair tool does not install all needed components by itself.

The installation package is not the problem since this same installation package I use all the time in other computers and no problem. I will try to uninstall it and reinstall, but I guess the same will happen.

Which is the SQL Server error log?

Regards
Jaime
Jaime Stuardo 71 Reputation points

2022-04-25T12:38:37.677+00:00

Hello again, @CathyJi-MSFT . I have tried to uninstall SQL Server and I could, however, I could not uninstall Microsoft ODBC Driver 17 for SQL Server due to the same reason. It seems in order to do anything with SQL Server I need to solve that redistributable problem first, but if I do what that message box says, it still does not work,.

Regards,

Answer 2

Erland Sommarskog 121.4K MVP Volunteer Moderator

I have a vague memory of that the installer is picky about the version number. You may have the redistributable installed, but not the right version. (And yours may be too new!)

You could try uninstall the redistributable runtime, and see what happens.

But as I said, this is a vague memory, and I may be wrong.

Jaime Stuardo 71 Reputation points

2022-04-25T22:18:07.51+00:00

Hello @Erland Sommarskog . I tried to uninstall SQL Server 2019 but the same error for VC++ distributable was shown when I tried to uninstall ODBC driver. That was the only component I could not uninstall. I decided to update ODBC driver to the last version. Then, I tried to install SQL Server 2019 and more errors were shown, besides VC++ redistributable error.

The result, SQL Server 2019 got damaged in a more critical way.

I had to reset Windows to factory and I am in that process now. It is very strange, a brand new device, just set up, needed to reset to factory. I hope I would be able to install SQL Server 2019 at this time.

Regards
Jaime
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2022-04-26T21:26:29.503+00:00

That's awful to hear. I'm sorry that my vague idea sent you further down the rabbit hole.

Answer 3

Hi anonymous usertuardo-5606,

> Which is the SQL Server error log?

SQL server 2019 error log is located at C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log by default as below screenshot. Please check the latest created one.

> I had to reset Windows to factory and I am in that process now. It is very strange, a brand new device, just set up, needed to reset to factory. I hope I would be able to install SQL Server 2019 at this time.

Waiting for your good news. And if you have any issue, please feel free to let us know.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Share via

Problem repairing SQL Server 2019

3 answers

Your answer