UNABLE TO INSTALL SQL SERVER(setup.exe)

Umair Shahbaz 96 Reputation points
2021-01-21T08:39:51.537+00:00

Hi,
I'm trying to install sql server but it's always showing me the same message:
"unable to install SQL Server (setup.exe) at nearly 90% of installing.

here is the log file:
59072-detail.txt

if someone can please help me out,

Thanks you in advance.

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,869 questions
0 comments No comments
{count} votes

Accepted answer
  1. Umair Shahbaz 96 Reputation points
    2021-01-22T06:50:53.863+00:00

    I performed a custom installation and tried to configure mixed authentication mode, but it didn't work. the same thing happens, at nearly 90% of the installation, it keep showing me an error. But while installing thrue custom installation, i remarked that i had a warning for windows defender (to check if windows defender will allow the creation of new port). So i done a bakeup of my windows and restored it. Before installing my antivirus or updating windows defender, i installed SQL server and this time it worked perfectly.

    Thanks you so much for your help, I learned a lot :)

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Shashank Singh 6,246 Reputation points
    2021-01-21T09:07:02.903+00:00

    Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
    (01) 2021-01-21 09:25:46 Slp: HResult : 0x851a001a

    This is the prominent error I see. This error usually means SQL Server was able to install SQL Server but was not able to bring DB services online due to some reason. The reason is mentioned in SQL Server errorlog file.

    Please refer to Article 24364.sql-server-troubleshooting-could-not-find-database-engine-startup-handle-error-during-installation.aspx

    There are 2 solutions

    1. Go to SSCM, if you see DB engine service try starting it, If it does not starts change service account to NY Authority\System and try restarting.
    2. If error is related to SQL Server not coming online due to master and other databases not coming online. See the location mentioned in article, and post the contents of errorlog here. The errorlog location is

    Drive:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.

    0 comments No comments

  2. Umair Shahbaz 96 Reputation points
    2021-01-21T11:06:52.803+00:00

    Thank you for your fast response. I managed to keep it working but now when i attempt to connect to the server in SSMS it's showing me a new error: please view the file attached.
    59164-capture.png

    59165-capture.png