How to: Install and Configure SharePoint Integration on a Stand-alone Server

1. Run the Installation wizard. For more information, see How to: Install SQL Server 2008 R2 (Setup) in SQL Server Books Online.

2. Click Installation in the left side of the Wizard and then click New installation or add features to an existing installation.

3. Click ok on the Setup Support Rules page, assuming all rules passed.

4. Click Install on the Setup Support Files page.

5. Click Next after the support files have completed installing and the support rules show status of passed. Review any warnings or blocking issues.

6. Type the appropriate product key and click Next on the Product Key page.

7. 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.

8. Click SQL Server Feature Installation on the Setup Role page.

9. Click Database Engine Services, Reporting Services and Management Tools Complete on the Feature Selection page. Click Next to continue.

   

10. Click Next on the Installation Rules page. Review any warnings or blocking issues.

11. Accept the default instance of MSSQLSERVER on the Instance Configuration page and click Next.

12. Click Next on the Disk Space Requirements page.

13. Enter appropriate credentials on the Server Configuration page and click Next. Note that SharePoint 2010 products in a farm configuration require domain accounts for service configurations. The single server installation is still considered a farm configuration and you will choose farm options when you run the SharePoint installation later in this article.

14. Add appropriate accounts to the list of SQL Administrators on the Database Engine Configuration page and click Next.

15. Click Install the SharePoint integrated mode default configuration on the Reporting Services Configuration page.

    

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

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

18. On the Ready to Install page, review the installation summary and then click Next. The summary should include a Reporting Services node that will include the installation mode value of DefaultSharePointMode as well as the account information.

Verification: After setup is finished, you can verify the Reporting Services service is running by running the Sql Server Configuration Manager. While in the configuration manager, click SQL Server Services and verify the SQL Server Reporting Services service is running.

Top

1. Run PreRequisiteInstaller.exe from the installation media.

2. Note SQL 2008 R2 Reporting Services SharePoint 2010 Add-in is in the list of products the preparation tool will install. Click Next.

   The add-in can also be downloaded and installed separately. For more information, see Where to find the Reporting Services add-in for SharePoint Products

3. On the Installation complete page, you should see in the list SQL 2008 R2 Reporting Services SharePoint 2010 Add-in: installed successfully

4. Click Finish

   Top

1. Run Setup.exe from the installation media.

2. Enter the product key and click Continue.

3. Review the software license terms and then click the box to accept the agreement. Click Continue.

4. On the installation type page, click Server Farm.

   

5. On the Server Type page, click Complete and then click Install Now.

   

6. When installation completes, you will see the Run Configuration Wizard page. Verify that the check box is selected for Run the SharePoint Products Configuration Wizard now. The Wizard will guide you through setting up your initial SharePoint environment. If you are following these procedures to a Reporting Services server to an existing farm, the wizard will join the new server to your existing farm.

7. Click Close.

   Top

1. After the SharePoint installation closes, the SharePoint Products Configuration Wizard runs. The SharePoint 2010 Products Configuration Wizard can also be started by clicking the Start button and then opening the Microsoft SharePoint 2010 Products folder.

2. On the Welcome to SharePoint Products page, click Next. You will see a warning message that some services need to be restarted during the configuration process. Click Yes.

3. On the Connect to a server farm page, click Create a new server farm and click Next.

4. On the Specify Configuration Database Settings page:

   1. Type in the name of your server into the Database server text box.

   2. Use the default Database name of SharePoint_Config.

   3. Type in an appropriate Username and Password for the database access account.

   4. Click Next.

5. On the Specify Farm Security settings type in a desired passphrase and click Next.

6. On the Configure SharePoint Central Administration Web Application page:

   1. Type in port number.

   2. Click the desired authentication provider.

   3. Click Next.

7. On the Completing the SharePoint Products Configuration Wizard page, verify the settings and click Next to run the wizard.

8. On the Configuration Successful page, review the Central Administration settings and Click Finish. The Configuration Wizard will close and your browser will open and load the SharePoint Central Administration page and the Initial Farm Configuration Wizard.

   Top

1. The Farm configuration wizard opens. Click Start the wizard, and type in your service account.

2. Review the default list of services that will be enabled. Click Next. This process takes several minutes.

3. On the next page, you can create a new top-level web site collection for your SharePoint installation. The site will include a default document library named Shared Documents. You can use that document library or create another to use for working with Reporting Services items. Type in a title and a brief description for the site.

4. Type in a site URL, for example http://[servername]/sites/YourNewSiteName.

5. Verify the default option of Team site is selected for the template and click OK.

6. The creation of the site collection will run for several minutes. Click Finish.

   Top

1. Review Plan for host-named site collections (SharePoint Server 2010).

2. If SharePoint application’s internal and public addresses are identical, review Publishing a SharePoint application with identical internal and public host addresses.

3. Either configure the host names that are mapped to the loopback address or disable the loopback check as described in the knowledgebase article, You receive error 401.1 when you browse a Web site that uses Integrated Authentication and is hosted on IIS 5.1 or a later version.

   Top

1. You can verify an installation by opening a browser as an administrator and browsing to the report server.

2. The URL should resemble http://example-server-name:8080/reportserver. You can also use: https://localhost/reportserver. This URL is to the proxy endpoint. After you add report server items to a SharePoint library, you can open a browser window to this URL to view items on the site.

3. You should see a message similar to the following. This message indicates Reporting Services is installed for SharePoint mode but Reporting Services has not yet been integrated with SharePoint.

   The report server has encountered a configuration error. If the report server is configured to use SharePoint integrated mode, verify that the server is joined to a SharePoint farm and that the Report Server service account has been granted access to the SharePoint farm. (rsServerConfigurationError)

   Top

• The Reporting Services and SharePoint environments are now installed but they are not integrated together. In order to complete the integration of Reporting Services and your SharePoint deployment, see How to: Configure Report Server Integration in SharePoint Central Administration.

  Top