Report server setup

One indication that a port might be closed is a blank page when you attempt to open the web portal from a remote client computer. If you are using Windows Vista or Windows Server , additional steps are required before you can open the web portal locally. Verify your installation by creating folders, uploading items, and running reports. Follow the instructions in Verify a Reporting Services Installation to verify your installation.

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? You can use the Reporting Services Configuration Manager to create and configure a connection to the report server database.

You can also select an existing report server database that already contains the content you want to use. Configure a Native mode scale-out deployment. Reporting Services supports a deployment topology that allows multiple report server instances use a single, shared report server database. To deploy a report server scale-out deployment, you use the Reporting Services Configuration Manager to connect each report server to the shared report server database.

Backup, restore, or replace the symmetric key that is used to encrypt stored connection strings and credentials. You must have a backup of the symmetric key if you change the service account, or move a report server database to another computer. Configure the unattended execution account.

This account is used for remote connections during scheduled operations or when user credentials are not available. Configure report server e-mail. Reporting Services includes a report server e-mail delivery extension that uses a Simple Mail Transfer Protocol SMTP to deliver reports or report processing notification to an electronic mailbox.

The Reporting Services Configuration Manager does not help you manage report server content, enable additional features, or grant access to the server. Full deployment requires that you also use SQL Server Management Studio to enable additional features or modify default values, and the web portal to grant user access to the server.

The Reporting Services Configuration Manager is version-specific. If you are running older and newer versions of Reporting Services side-by-side on the same computer, you must use the Reporting Service Configuration manager that comes with each version to configure each instance.

Local system administrator permissions on the computer that hosts the report server you want to configure. If you are configuring a remote computer, you must have local system administrator permissions on that computer as well.

Use the following procedure to verify that the reporting services point installation was successful. If you see reports in the Reports subfolder of the Reporting node in the Monitoring workspace in the Configuration Manager console, you can skip this procedure. Specify a date and time for a period before you installed the reporting services point, and then select OK.

Verify status message ID This status message indicates that the reporting services point was successfully installed. Open the Srsrp. Look for the string Installation was successful. Step through this log file starting from the time that the reporting services point was successfully installed. Verify that the report folders were created, the reports were deployed, and the security policy on each folder was confirmed. After the last line of security policy confirmations, look for the string Successfully checked that the SRS web service is healthy on server.

When you create or edit reports in the Configuration Manager console, Configuration Manager opens Report Builder to use as the authoring environment.

Regardless of how you author your Configuration Manager reports, you need a self-signed certificate for server authentication to the site database server.

Configuration Manager automatically installs the certificate on the site server and any SMS Provider roles. You can create or edit reports from the Configuration Manager console when you run it from one of these servers. When you create or modify reports from a Configuration Manager console on a different computer, export the certificate from the site server.

The specific certificate's friendly name is the FQDN of the site server in the Trusted People certificate store for the local computer. Add this certificate to the Trusted People certificate store on the computer that runs the Configuration Manager console. After you install this role, you can modify the site database connection and authentication settings in the reporting services point properties.

To list only site systems that host the reporting services point, right-click the Servers and Site System Roles node, and select Reporting services point. Select the site system that hosts the reporting services point. Then select the Reporting service point site system roles in the details pane. On the Site Role tab of the ribbon, in the Properties group, select Properties.

You can modify the following settings in the Reporting Services Point Properties :. For more information about these settings, see the descriptions in the section to Install the reporting services point on a site system. If you don't follow this process, you'll see errors when you run or edit reports from the Configuration Manager console. You can continue to run and edit reports successfully from a web browser.

You can select the default reporting services point that you use to manage reports. The site can have more than one reporting services point, but it only uses the default server to manage reports. Use the following procedure to configure report options for your site. In the Configuration Manager console, go to the Monitoring workspace, expand Reporting , and then select the Reports node.

On the Home tab of the ribbon, in the Settings group, select Report Options. If it doesn't show any servers, verify that you installed and configured a reporting services point in the site. For more information, see Verify installation. Otherwise you'll see an error, the default report server won't save, and you can't create or edit reports. Operations and maintenance for reporting. Skip to main content. This browser is no longer supported.

Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Important The user account you use to create the reporting services point must have Read access to the site database.