SQL SERVER – All the Features not Listed While Installing SQL Server

I was trying to install SQL BI features for one of the assignments I had got. In the setup wizard when I reached the Features Page I got a surprise of my life. There were many features missing! I could not see features available while installing SQL Server listed here:

  • SQL Analysis Service
  • SQL Reporting Services
  • SQL Integration Services
  • Data Quality Services
  • Polybase Query Service for External Data

SQL SERVER - All the Features not Listed While Installing SQL Server feature-miss-01

SOLUTION/WORKAROUND

After a brief period fiddling with this issue, I was able to figure that the corresponding MSI files for these missing features were not even present in the setup media. These are usually present in the below path,

Solarwinds

<Media>\x64\Setup

This could have happened when I was extracting the ISO image. I quickly extracted the ISO once again and found that this time I was able to see the missing MSI files and I was also able to see the features listed in the setup wizard,

SQL SERVER - All the Features not Listed While Installing SQL Server feature-miss-02

This was a really interesting behavior where setup doesn’t give any error. It just removes the component from the list! I hope you find this blog post interesting as I personally did not ever encountered such an error and for me, it was a strange error.

Please leave your opinion in the comments section.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , ,
Previous Post
SQL SERVER – Always On Replica Disconnected After Changing SQL Server Service Account
Next Post
SQL SERVER – SQL Server Agent Not Starting – Failed to Initialize SQL Agent Log (Reason: Access is Denied).

Related Posts

1 Comment. Leave new

  • Thank you for this post, I was going crazy trying to figure out why the features weren’t there.

    Reply

Leave a Reply

Menu