SharePoint integrated mode configuration in SQL Server2012 Reporting Services

Preface

http://www.microsoft.com/zh-CN/download/details.aspx?id=29068#

There is no "Sharepint integration" mode selection (in new) on the SQL server2012 report Configuration Manager, such as:

What's going on here? Later through the query information to know, as follows:

Important Notes

Starting with the version of SQL Server 2012, Reporting Services Configuration Administrators are not designed to manage SharePoint mode report servers. The sharepoing mode is managed and configured by using the Sharepoing Admin Center and PowerShell scripts. For information about installing and configuring Reporting Services for SharePoint integrated mode, see Installing Reporting Services SharePoint mode as a single-server farm in SQL Server Books Online.

Important Notes

Configuring and Managing Reporting Services SharePoint mode no longer requires or supports Reporting Services Configuration Manager. Use SharePoint Central Administration to configure the report server in SharePoint mode. For more information, see Managing Reporting Services Service applications.

Installing the SQL Server2012 database

· This topic does not cover the installation of SharePoint 2010 products. For more information, see the Guide to using SQL Server BI features in a SharePoint farm.

· These procedures apply to configuring a SQL Server 2012 report server and not to a previous version of a report server that is not using the SharePoint Shared services architecture. For example, SQL Server Reporting Services Report Server and SQL Server R2 Reporting Services report Server.

· Verify that the SharePoint 2010 Management Service is started in Windows Server Manager.

Database considerations for single-server configuration

· Reporting Services and SharePoint products and technologies use SQL Server relational databases to store application data.

· SQL Server Reporting Services (SSRS) requires a SQL Server evaluation version of the compatible SQL engine instance. For more information about hardware and software requirements, see Hardware and software requirements for installing SQL Server 2012.

· If you have a DB instance installed, SharePoint products can use an existing DB instance. If the database Engine instance is not installed, SharePoint product Setup installs SQL Server Express Edition for use with the SharePoint application database.

· A report server instance cannot use SQL Server Express Edition for its database. However, the SQL Server Express Edition instance that is installed by SharePoint products can coexist with other versions of the database engine that you may also install.

To install the Reporting Services Report Server in SharePoint mode

1. Run the SQL Server Setup Wizard.
2. Click Installon the left side of the wizard, and then click New SQL Server Standalone installation or add features to an existing installation.
3. On the Setup Support Rules page, click OK, assuming that all the rules have passed validation.
4. On the Setup Support Files page, click Install.
5. After the support files have been installed and the support rules show "passed" status, click Next. View any warnings or issues that prevent installation.
6. On the Product Key page, type the key or accept the default key for Enterprise Evaluation Edition.

Click Next.

7. Read and accept the license terms. Microsoft appreciates the fact that you clicked to agree to send feature usage data to help improve product functionality and support.

Click Next.

8. On the Installation Roles page, select SQL Server feature installation.

Click "Next"

9. On the Feature Selection page, select the following options:

· Reporting Services–sharepoint

· Reporting Services Add-in for SharePoint 2010 products . The installation wizard options for installing add-ins are new in SQL Server version 2012.

· If you do not have an instance of SQL Server installed, you can also select Database Engine Services and Administrative Tools-complete to provide a complete environment.

Click Next.

10. On the Installation Rules page, click Next. View any warnings or issues that prevent installation.
11. If you have selected the Database Engine service, on the instance configuration page, accept the default instance of MSSQLSERVER , and then click Next. Unlike the previous Reporting services architecture, the Reporting services Shared services architecture is not based on instances.
12. Read The disk space requirements page, and then click Next.
13. On the Server Configuration page, type the appropriate credentials. If you want to use the Reporting Services Data alert or subscription feature, you need to change the startup type of SQL Server Agent to automatic.

Click Next.

14. If you selected the Database engine service, you will see the Database Engine configuration page. Add the appropriate account to the list of SQL administrators, and then click Next.
15. On the Reporting Services Configuration page, you will see that the Install only option is selected. This option installs the report server file, which will not configure the SharePoint environment for Reporting Services. After the SQL Server installation is complete, you need to configure the SharePoint environment according to the content of the other chapters in this topic. This includes installing the Reporting services Shared service and creating the Reporting Services service application.

16. You can help Microsoft improve SQL Server features and services by clicking the check box for sending error reports on the Error Reporting page.

Click Next.

17. Review any warnings, and then on the install Configuration Rules page, click Next.
18. On the Ready to install page, review the installation summary, and then click Next. The summary will contain a Reporting Services node that will contain the installation mode values for Sharepointfilesonlymode and the account information.

Configure report Services in SharePoint integrated mode

PowerShell Script configuration reporting Services

The required files have been installed during the execution of the SQL Server Setup Wizard, but the service needs to be registered with the SharePoint farm. The SQL Server 2012 release introduces PowerShell support for Reporting Services in SharePoint mode. The following steps will guide you through the process of opening the SharePoint Management Shell and running the cmdlet:

1. Click the Start button
2. Click the Microsoft SharePoint 2010 Products Group. Such as:

3. Right-click SharePoint Management Shell, and then click Run as Administrator.
4. Run the following PowerShell command to install the SharePoint service. When the command completes successfully, a new row is generated in the Management Shell. When the command completes successfully, no message is returned to the Management Shell:

Install-sprsservice

5. Run the following PowerShell command to install the service agent:

Install-sprsserviceproxy

6. Run the following PowerShell command to start the service, or review the note below for instructions on starting the service from SharePoint Central Administration:

Get-spserviceinstance-all |where {$_. Typename-like "SQL Server reporting*"} | Start-spserviceinstance

Such as:

You can also start a service from SharePoint central Administration, rather than by running a third PowerShell command. The following steps are useful for verifying that a service is running.

1. In SharePoint Central Administration, in the system settings Group, click Manage Services on server.

2. Locate the SQL Server Reporting Services service, and then click Startin the Action column.

3. The status of the Reporting Services service changes from stopped to started. If the Reporting Services service is not in the list, verify that the service has been installed with PowerShell.

Attention

If the Reporting Services service stays in the starting state and does not change to started, verify that the SharePoint 2010 Management Service is started in Windows Server Manager.

Create a Reporting Services service Application

This section provides steps and property descriptions that you use to create a new service application, in the case of viewing an existing service application.

1. In SharePoint Central Administration, in the application Management Group, click Manage Service Applications.

2. In the SharePoint ribbon, click the New button.
3. On the New menu, click SQL Server Reporting Services service Application.

Attention

If the Reporting services option does not appear in the list, the Reporting Services sharing service is not installed . Review the previous section to learn how to install the Reporting Services service using PowerShell CMDLT.

4. On the create SQL Server Reporting Services Service Application page, enter the name of the application. If you are creating multiple Reporting services service applications, a descriptive name or naming convention will help you organize long-term administrative operations.
5. In the application pool section, create a new application pool for the application (recommended). Using the same name as the service application as the name of the new application pool may make it easier for you to manage in progress.

Select or create a managed account for the application pool. Be sure to specify a domain user account. With a domain user account, you can use the Managed Accounts feature of SharePoint so that you can update your password and account information in one place. A domain account is also required if you plan to extend the deployment to include additional service instances that will run under the same identity.

6. In the database server , you can use the current server or select a different SQL Server.
7. In database name , the default value is Reportingservice_<guid> the name is a unique database name. If you want to type a new value, you must type a unique value because we recommend that you use a unique database for each service application.

8. In database authentication , the default value is Windows authentication. If you select SQL authentication, refer to the SharePoint Administrator's Guide for best practices on how to use this authentication type in a SharePoint deployment.

9. In the Web application affinity section, select the Web application that you want to set up for access by the current Reporting Services service application. You can associate a Reporting Services service application with a WEB application. If all current WEB applications are associated with an Reporting Services service application, a warning message is displayed.

10. Click OK.

SharePoint integrated mode configuration in SQL Server2012 Reporting Services