Installing SQL Server 2022

Question

Installing SQL Server 2022

Simeon Martins 20

I encountered the error in the image below while attempting to install SQL Server 2022.
Please any information on next steps to take to resolve this? Thank you.

This question is related to the following Learning Module

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-10-27T11:38:45.79+00:00

The image did not make it.

However, only the image may us tell us not that much. In C:\Program Files\Microsoft SQL server\160\Setup Bootstrap\Log, you find one folder per installation attempt. The files of most interest are Summary.txt and Detail.txt. Feel free to attach them here. Also, if there are files with the name ERRORLOG and a date in the folder, attach these as well.

Also, did you make multiple attempts before you posted here? Or did you post directly after the first failure? (No, I am not suggesting that you should retry, but knowing this may help with the diagnostics.)
Simeon Martins 20 Reputation points

2024-10-27T12:34:51.76+00:00

Thanks for your response. I didn't know the image will not be clear enough.
Below is the text on the image.

Please provide a valid location. The specified directory, "C:\Program Files\Microsoft SQL Server", is not valid because this directory is compressed or is in a compressed directory. Specify a directory that is not compressed.

I have uncompressed the 'C drive' and tried install the SQL again, yet it keeps giving me the same error message.
Thank you.
Simeon Martins 20 Reputation points

2024-10-27T12:41:55.2533333+00:00

Thanks for your response. I didn't know the image will not be clear enough. Below is the text on the image.

Please provide a valid location. The specified directory, "C:\Program Files\Microsoft SQL Server", is not valid because this directory is compressed or is in a compressed directory. Specify a directory that is not compressed.

I have uncompressed the 'C drive' and tried install the SQL again, yet it keeps giving me the same error message.
LiHongMSFT-4306 31,566 Reputation points

2024-10-28T01:38:04.4466667+00:00

Hi @Simeon Martins

Please check if the folder is compressed as answered below.

And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thanks for your understanding!

Accepted answer

0 additional answers

Your answer

Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-10-27T11:38:45.79+00:00

The image did not make it.

However, only the image may us tell us not that much. In C:\Program Files\Microsoft SQL server\160\Setup Bootstrap\Log, you find one folder per installation attempt. The files of most interest are Summary.txt and Detail.txt. Feel free to attach them here. Also, if there are files with the name ERRORLOG and a date in the folder, attach these as well.

Also, did you make multiple attempts before you posted here? Or did you post directly after the first failure? (No, I am not suggesting that you should retry, but knowing this may help with the diagnostics.)
Simeon Martins 20 Reputation points

2024-10-27T12:34:51.76+00:00

Thanks for your response. I didn't know the image will not be clear enough.
Below is the text on the image.

Please provide a valid location. The specified directory, "C:\Program Files\Microsoft SQL Server", is not valid because this directory is compressed or is in a compressed directory. Specify a directory that is not compressed.

I have uncompressed the 'C drive' and tried install the SQL again, yet it keeps giving me the same error message.
Thank you.
Simeon Martins 20 Reputation points

2024-10-27T12:41:55.2533333+00:00

Thanks for your response. I didn't know the image will not be clear enough. Below is the text on the image.

Please provide a valid location. The specified directory, "C:\Program Files\Microsoft SQL Server", is not valid because this directory is compressed or is in a compressed directory. Specify a directory that is not compressed.

I have uncompressed the 'C drive' and tried install the SQL again, yet it keeps giving me the same error message.
LiHongMSFT-4306 31,566 Reputation points

2024-10-28T01:38:04.4466667+00:00

Hi @Simeon Martins

Please check if the folder is compressed as answered below.

And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thanks for your understanding!

Answer 1

Erland Sommarskog 121.4K MVP Volunteer Moderator

Thanks for your response. I didn't know the image will not be clear enough. Below is the text on the image.

Do you actually see an image? I don't.

Very apparently the folder is still compressed. Go to C:\Program Files\Microsoft SQL Server, right-click and Select properties. Then click on the Advanced button. Make sure that the Compress checkbox is cleared.

User's image You can also open a command-line window and move to C:\Program Files\Microsoft SQL Server and run compact /u. If you get permission errors, open the command-line window with Run as Administrator.

Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-28T08:45:27.9066667+00:00

Hi Simeon Martins,

Just checking in to see if you had a chance to see the previous answer. Please let me know if it was helpful and don't hesitate to reach out to us if you face any issue.

Thank you.
Simeon Martins 20 Reputation points

2024-10-28T13:34:30.1333333+00:00

Thank you @Erland Sommarskog and @LiHongMSFT-4306

Your responses were helpful, I uncompressed the folders, and tried to install again, and after multiple attempts, the installation went through; however the main purpose hasn't been achieved yet, as this was just a step to help me execute a step in one my my training sessions on the Microsoft Learn portal: to Get into Power BI through SQL Data.
I'll keep trying other alternatives/options.
Thank you for time, and input.
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2024-10-28T21:12:59.4033333+00:00

however the main purpose hasn't been achieved yet, as this was just a step to help me execute a step in one my my training sessions on the Microsoft Learn portal: to Get into Power BI through SQL Data.

However that would be another Question. This specific question about installoing SQL Server appears to be resolved, and I would suggest that you accept my Answer.

If you have further questions, you are welcom to ask them here. If they are related to SQL Server use the SQL Server tag. If they are related to Power BI, but not specifically the training module, it's a little more complicated as Power BI as such is not supported in Microsoft Q&A, but have its own forum elsewhere.
Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator

2024-10-29T04:44:33.1233333+00:00

Hi Simeon Martins,

Glad to hear that your issue got resolved. Please don't hesitate to reach out to us if you have any further queries.

Thank you.

Share via

Installing SQL Server 2022

0 additional answers

Your answer