So today i went to install reporting services for SQL 2008 R2 and came across the following error when trying to add an additional feature in the SQL setup: “The instance ID is required but it is missing”.

So i tried copying the media to the server and selecting it from Programs and features and still the same error.

I downloaded SQL Express 2008 R2 with Advanced features, ran the setup from this file and i was able to add the Reporting Services role.

Advertisements
Advertisements