SQLServer 2019 Developer installation failing with errorcode -2061893606

Question

SQLServer 2019 Developer installation failing with errorcode -2061893606

Ravi Ayitha 1

Hi

SQLServer 2019 developer edition installation failing with error code -2061893606.
Uninstalled previous unsuccessful installations of SQL Server 2019 and did restart.

Ravi Ayitha 1 Reputation point

2022-09-16T14:34:38.86+00:00

Attached Screenshot
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2022-09-19T03:05:04.937+00:00

Hi @Ravi Ayitha ,

Any update for this thread? Please check your SQL server error log as the screenshot mentioned, and share us the error log for analysis.

3 answers

Your answer

Ravi Ayitha 1 Reputation point

2022-09-16T14:34:38.86+00:00

Attached Screenshot
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2022-09-19T03:05:04.937+00:00

Hi @Ravi Ayitha ,

Any update for this thread? Please check your SQL server error log as the screenshot mentioned, and share us the error log for analysis.

Answer 1

It looks like your uninstall did not complete successfully and you still have pieces of SQL installed. The traditional uninstall steps are given here. Then you will likely need to follow some additional steps as given here. When you're done, reboot. Ensure there are no SQL Server related services running.

Be aware that many apps (such as Visual Studio and SSMS) create folders under Microsoft SQL Server. Determining which ones are for SQL Server and which ones are for others can be very difficult. After uninstalling and reinstalling SQL you may need to repair the installation of any SQL-related tools as well.

Answer 2

The error message tells you that SQL Server did not start when Setup wanted to run configuration steps. As the error message says, you need to look into the SQL Server error log to find out why. You find the log in C:\Program Fles\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\LOG\ERRORLOG.

If the errorlog includes a message about 256 misaligned reads and reverting to synchronous mode, check out this aritcle for workarounds.

If that message is not present, upload the errorlog (rename to be called errorlog.txt, or else the forum software will not agree to attach it), so we can look at it.

Answer 3

Ravi Ayitha 1

HI

Thanks for the responses.
Please find the attached error log.242340-errorlog.txt

Ravi Ayitha 1 Reputation point

2022-09-19T13:49:19.343+00:00

Uninstalled SQL Server 2019. And installed SQL Server 2019 Express Edition.
Installation successful. Thanks for the responses.
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff

2022-09-20T03:20:59.437+00:00

Hi @Ravi Ayitha ,

Thanks for your reply. I am glad to hear that you have installed SQL server 2019 Express successfully. But SQL server agent job is not supported in SQL server Express edition. Did you try to install SQL server developer again?

I read the SQL server error log that you offered, I found below error.

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

You can search this error message in google and try the solutions from blogs. Such as below one.

https://blog.sqlauthority.com/2018/11/12/sql-server-initializing-the-fallback-certificate-failed-with-error-code-1-state-20-error-number-0/

Share via

SQLServer 2019 Developer installation failing with errorcode -2061893606

3 answers

Your answer