How to fix an error when installing MS SQL

Oskar Nowak 20 Reputation points
2024-03-27T21:17:35.4233333+00:00

Hello,
I was trying to install MS SQL on my computer but unfortunately i keep getting error with database engine startup handle. I tried to find answers for hours in various forums but nothing I found worked. Below I place screenshot together with error logs and hope that someone will know how to help me fix this :D
error

Here is the first file:

ERRORLOG.txt

And here is the second:

Summary_Oskar_20240327_210536.txt

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,715 questions
0 comments
Accepted answer
  1. MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
    2024-03-28T03:07:21.05+00:00

    Hi，@Oskar Nowak

    Found this in ERRORLOG.txt

     2024-03-27 21:10:10.57 spid32s Error: 17190, Severity: 16, State: 1. 2024-03-27 21:10:10.57 spid32s Initializing the FallBack certificate failed with error code: 15, state: 29, error number: 2. 2024-03-27 21:10:10.57 spid32s Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.

    The above issue may be caused by two types of reasons:

    1. An invalid certificate.
    2. SQL Server is unable to access the specified certificate. To fix this issue ASAP .You may try to change the service account to an LocalService.

    Refer tohttps://learn.microsoft.com/en-us/archive/msdn-technet-forums/56f14665-3f00-41ff-b002-bb5e86b3f219

    Steps：User's image

    If the above is unable to resolve the issue, you can try the following method：

    Refer to

    Configure SQL Server to use a self-signed certificate:

    1.Open the Registry Editor and navigate to the following registry key (the registry path may vary slightly depending on the instance number):

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Certificate

    2.Clear the value of the Certificate.

    3.Open the Microsoft Management Console (MMC) and add the Certificate Management console. Delete all certificates in both the Local Computer certificate store and the Current User certificate store that have a subject field that matches the server hostname (before deleting, you may want to export the certificates as a backup for future use).

    This should allow SQL Server to use a self-generated certificate in most cases.

    Use the self-signed certificate automatically created by SQL Server

    To check the certificate, you can refer to Microsoft's documentation on certificate requirements for SQL Server. Certificate requirements for SQL Server - SQL Server | Microsoft Learn

     

    Best regards,

    Mikey Qiao

     

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

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 101K Reputation points MVP
    2024-03-27T21:54:40.5833333+00:00

    There are a couple of errors in your ERRORLOG related to creating a self-signed fallback certificate. These errors are usually due to that the profile for the default user in Windows is corrupted.

    How to fix that is a Windows question and not an SQL Server question. Google may help you. I once ran into this problem myself. I seem to recall that a common advice was to copy the default profile from another computer. I think that my resolution was to restore the profile from a backup, but not everyone may have a backup of their home machine.

    Another option is to change the service account to an existing one like LocalService, but I think it is better to stick with the default which is a new, dedicated, service account for your SQL Server instance. And anyway, that corrupted default user could bite you again later if you do not sort it out.