Sql-server – Why SQL Server installs multiple services for AS and RS, but only one for IS

Maintenance plans are stored in msdb.dbo.sysssispackages like any other SSIS packages that are stored to SQL Server. I have a handy post on SSIS Package Extract from MSDB that should cure what ails you.

Following up on my comment, you have to select ENU\x64\SQLEXPRADV_x64_ENU.exe for installation.

Download link.

Then run the installation package and follow instruction until you get feature selection page.

Follow rest of the steps and complete the installation.

Now Verify the RS installation :

Note: You must be logged in as a member of the local administrators group on the computer where SQL Server 2012 Express is installed.

1. Navigate to Start -> All Programs -> Microsoft SQL Server 2012 -> Configuration Tools -> Reporting Services Configuration Manager.

2. In the RS Configuration Connection dialog, make sure that your local report server instance (for example SQLExpess) is selected and click Connect.

   

3. In the RS Configuration Manager left pane, select Web Service URL.

   

4. Make sure that the Virtual Directory parameter is set to ‘ReportServer_’ (‘ReportServer_SQLEXPRESS’ for the SQLEXPRESS instance), and that the TCP Port is set to 80. Click Apply.

5. In the Reporting Services Configuration Manager left pane, select Database.

6. On this page, ensure that the SQL Server Name and Database Name fields contain correct values. If not, click the Change Database button and complete the Report Server Database Configuration wizard.

7. In the Reporting Services Configuration Manager left pane, select Report Manager URL.

8. On this page, ensure that the Virtual Directory parameter is set correctly, and that the URL is valid.

9. Click Exit to close the RS Configuration Manager.