Install Reporting Services in SharePoint Mode

·         Run the SQL Server Installation Wizard (Setup.exe).

·         Click Installation in the left side of the wizard and then click New SQL Server stand-alone installation or add features to an existing installation.

·         Click OK on the Setup Support Rules page, assuming all rules passed.

·         Click Install on the Setup Support Files page. Depending on what is already installed on your computer, you might see the following message:

·         “One or more affected files have operations pending. You must restart your computer after the setup process is completed.”

·         Click Ok.

·         Click Next after the support files have completed installing and the Support Rules pages show a status of Passed. Review any warnings or blocking issues.

·         On the Installation Type page, click Add features to an existing instance of SQL Server 2012. Select the correct instance in the drop-down list and click Next.

·         If you see the Product Key page, type your key or accept the default of the ‘Enterprise Evaluation’ edition.

·         Click Next.

·         If you see the License terms page, review and accept the license terms. Microsoft appreciates you clicking to agree to send feature usage data to help improve product features and support.

·         Click Next.

·         If you see the Setup Role page, select SQL Server Feature Installation

·         Click Next

·         Select the following on the Feature Selection page:

·         Reporting Services – SharePoint

·         Reporting Services add-in for SharePoint Products.

·         note The installation wizard option for installing the add-in is new with the SQL Server 2012 release.

·         If you do not already have an instance of SQL Server Database Engine, you could also select Database Engine Services and Management Tools Complete for a complete environment.

·         Click Next.

·         If you see the Installation Rules page. Review any warnings or blocking issues. Then click Next

·         If you selected the Database Engine services, accept the default instance of MSSQLSERVER on the Instance Configuration page and click Next.

·         noteThe Reporting Services SharePoint service architecture is not based on a SQL Server "instance" as was the previous Reporting Services architecture.

·         Review the Disk Space Requirements page and click Next.

·         If you see the Server Configuration page type appropriate credentials. If you want to use the Reporting Services data alerting or subscription features, you need to change the Startup Type for SQL Server Agent to Automatic. You may not see the Server Configuration page, depending on what is already installed on the computer.

·         Click Next.

·         If you selected the Database Engine services, you will see the Database Engine Configuration page, add appropriate accounts to the list of SQL Administrators and click Next.

·         On the Reporting Services Configuration page you should see the Install only option is selected. This option installs the report server files, and does not configure the SharePoint environment for Reporting Services.

·         Help Microsoft improve SQL Server features and services by clicking the check box to send error reports on the Error Reporting page.

·         Click Next.

·         Review any warnings and then click Next on the Installation Configuration Rules page.

·         On the Ready to Install page, review the installation summary and then click Next. The summary will include a Reporting Services SharePoint Mode child node that will show a value of SharePointFilesOnlyMode. Click Install.

·         The installation will take several minutes. You will see the Complete page with the features listed and the status of each feature. You may see an information dialog indicating the computer needs to be restarted.