question

LuisAaronAvilesRobles-0022 avatar image
0 Votes"
LuisAaronAvilesRobles-0022 asked LuisAaronAvilesRobles-0022 commented

Failed to Install SQL Server 2019 in Windows 10, Services doesn't show

I'm trying to install SQL Server 2019 in my work machine, using windows 10 Enterprise. I have already tried the following:

  • Running the installer as Administrator

  • Ensuring Windows is updated

  • Not installing R and Python packages

  • Downloading the installer and picking the "Express Core" option to install a reduced version.

What is happening? When the installer is working at some point it closes and doesn't show a "installation complete" window. However, if I look for "SQL Server 2019" I can open it but the services doesn't show. See image bellow:
202048-image.png

202103-summary.txt

I have ran a Discovery Report and shows the following:

202087-image.png
I have also check sector sizes: PhysicalBytesPerSectorForAtomicity : 4096



I have attached the log summary, please let me know if there is something else I can try. Thanks!

sql-server-general
image.png (13.7 KiB)
image.png (19.4 KiB)
summary.txt (2.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered LuisAaronAvilesRobles-0022 commented

There is also a file detail.txt with more details about the installation.

However, since this is a corporate machine, I think you should talk with your IT department. My gut feeling is that they have anti-malware software that does not find some component on the white-list for your machine and kills Setup.

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Yes, some permissions aren't allowing the installation to finish. The only workaround was to use Docker as an alternative.

1 Vote 1 ·

THanks for your reply, please find attached some logs of the last instalation. Let me know if you want an specific file. Thanks,

202833-summary-laviles01-20220516-191721.txt202806-summary-laviles01-20220516-191715-landingpage.txt


0 Votes 0 ·
ErlandSommarskog avatar image ErlandSommarskog LuisAaronAvilesRobles-0022 ·

Don't you have any details.txt?

Have you spoken to your IT folks?

0 Votes 0 ·

Here is a detail.txt document from last installation. Let me know any thoughts. I'm still waiting if there is any support I can get in case this is a permissions related issue. Thanks,

202905-detail.txt


0 Votes 0 ·
detail.txt (2.3 MiB)
Show more comments
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered LuisAaronAvilesRobles-0022 commented

Hi @LuisAaronAvilesRobles-0022,

According to your summary log, you did not install SQL server 2019 successfully. Your installation seems stopped after checking rules. Your installation did not have the process of feature selection, instance configuration, server configuration, etc.

Please follow below steps and read the detail steps from this blog Step By Step Installation Of Microsoft SQL Server On Windows System. This blogs share us the screenshots of detail installation steps.

  1. Please download SQL server 2019 Express from this MS link.

  2. Run run the download file, please choose the third option – Download Media.

  3. Run install media file (ISO file) downloaded in above section as administrator.

  4. Then follow steps of SQL server installation center wizard to install SQL 2019 Express. You can refer to the blog that I offered above.

This blog share us the steps of installing SQL 2019 developer, installing SQL 2019 Express is same as this, the only difference is that choose Express edition during installation.


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







· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, thanks for the reply, however the output is the same. The options when downloading Express Edition are not the same, as you can see bellow:
202070-image.png

I have already tried with the Express Core and the Express Advanced version. I will see if I can install de Developer Edition although that is not the one I need.

Let me know any other thoughts.

Thanks
202162-summary.txt


0 Votes 0 ·
image.png (64.1 KiB)
summary.txt (2.5 KiB)

I have also used the Developer Edition installer but using the Express option:
202172-image.png
however the outup was the same.
202144-image.png

The installation doesn't finish. It crashed just by the end.202030-summary.txt


0 Votes 0 ·
image.png (67.4 KiB)
image.png (72.4 KiB)
summary.txt (4.8 KiB)

I have also tried to install the developer version but the output is the same:
202095-image.png
The installation was almost complete and then it crashed :( 202090-summary.txt

Please let me know any other ideas. Thanks,


0 Votes 0 ·
image.png (38.5 KiB)
summary.txt (3.4 KiB)
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered LuisAaronAvilesRobles-0022 commented

Hi @LuisAaronAvilesRobles-0022,

Please use SQL server 2019 Express package from this MS link. Then follow below steps;
202262-screenshot-2022-05-16-153723.jpg
202202-screenshot-2022-05-16-153743.jpg
202139-screenshot-2022-05-16-153912.jpg
202127-screenshot-2022-05-16-154011.jpg
202128-screenshot-2022-05-16-154034.jpg
202242-screenshot-2022-05-16-154103.jpg
202204-screenshot-2022-05-16-154150.jpg
202205-screenshot-2022-05-16-154217.jpg
202263-screenshot-2022-05-16-154257.jpg
202140-screenshot-2022-05-16-155158.jpg
202189-screenshot-2022-05-16-155306.jpg


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



· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Cathyji-msft thanks for your reply, I made sure to follow step by step your recommended steps, however, the output is the same. Just by the end of the installation the program closes and doesn't finish. Is there something about the system that we should validate or consider?
202334-image.png
202296-image.png
202307-summary.txt

0 Votes 0 ·
summary.txt (2.5 KiB)
Cathyji-msft avatar image Cathyji-msft LuisAaronAvilesRobles-0022 ·

Hi @LuisAaronAvilesRobles-0022,

Please share us SQL server setup detail log for analysis. I need to find the reason of blocking when your steps is correct.

0 Votes 0 ·

Please find attached two detail documents from previous two intents to install. Thanks!
202924-detail.txt202849-detail-landingpage.txt


0 Votes 0 ·
detail.txt (2.3 MiB)

Hi @Cathyji-msft

Apparently some company setup permissions do not permit the installation to finish, thus it crashes. The workaround was to use Docker as an alternative.

0 Votes 0 ·