Install Reporting Services Native Mode Report Server (SSRS)

  • Article

A native mode report server can be installed from the SQL Server installation wizard or from the command line. In the setup wizard, you can select to either 1) install files and configure the server with default settings or to 1) only install the files and the server is not configured by the installation wizard. This topic reviews the Default configuration for native mode where Setup both installs and configures a report server instance. After Setup is finished, the report server is running and ready to use. A native mode report server runs as a stand-alone application server. Native mode is the default server mode.

This topic includes:

  • What is the Default Configuration?

  • When to Install the Default Configuration for Native Mode

  • Requirements

  • Default URL Reservations

  • Install Native Mode with the Installation Wizard

  • Install Native Mode with the Command Line

What is the Default Configuration?

Setup installs the following Reporting Services features when you select the default configuration for native mode option:

  • Report Server service (which includes the Report Server Web service, background processing application, and Report Manager)

  • The Reporting Services Configuration Manager

  • The Reporting Services command line utilities (rsconfig.exe, rskeymgmt.exe and rs.exe)

This option does not apply to shared features such as SQL Server Management Studio or SQL Server Data Tools (SSDT), which must be specified as separate items if you want to install them.

Setup configures the following for a native mode report server installation:

  • Service account for the Report Server service.

  • Report Server Web service URL.

  • Report Manager URL.

  • Report Server database.

  • Service account access to the report server databases.

  • DSN connection for the report server databases.

Setup does not configure the unattended execution account, report server e-mail, back up the encryption keys, or a scale-out deployment. You can use the Reporting Services Configuration Manager to configure these properties. For more information, see Reporting Services Configuration Manager (SSRS).

Arrow icon used with Back to Top linkTop

When to Install the Default Configuration for Native Mode

A default configuration installs Reporting Services in an operational state so that you can use the report server immediately after Setup is finished. Specify this mode when you want to save steps by eliminating any required configuration tasks you would otherwise have to perform in the Reporting Services Configuration tool.

Installing the default configuration does not guarantee that the report server will work after Setup is finished. The default URLs might not register when the service starts. Always test your installation to verify that the service starts and runs as expected.

Arrow icon used with Back to Top linkTop

Requirements

The default configuration option uses default values to configure the core settings required to make a report server operational. It has the following requirements:

  • You hardware should meet minimum hardware and software requirements for running Microsoft SQL Server. For more information, see Hardware and Software Requirements for Installing SQL Server 2012.

  • Reporting Services and SQL Server Database Engine must be installed together in the same instance. The Database Engine instance hosts the report server database that Setup creates and configures.

  • The user account used to run Setup must be a member of the local Administrators group and have permission to access and create databases on the Database Engine instance that hosts the report server databases.

  • Setup must be able to use the default values to reserve the URLs that provide access to the report server and Report Manager. These values are port 80, a strong wildcard, and the virtual directory names in the format ReportServer_<instance_name> and Reports_<instance_name>.

  • Setup must be able to use the default values to create the report server databases. These values are ReportServer and ReportServerTempDB. If you have existing databases from a previous installation, Setup will be blocked because it cannot configure the report server in the default configuration for native mode. You must rename, move, or delete the databases to unblock Setup.

If your computer does not meet all requirements for a default installation, you must install Reporting Services in files-only mode and then use the Reporting Services Configuration Manager to configure it after Setup is finished.

Do not try to reconfigure your computer only to allow a default installation to continue. Doing so could require several hours of work, effectively eliminating the time-saving benefit the installation option provides. The best solution is to install Reporting Services in files-only mode and then configure the report server to use specific values.

Arrow icon used with Back to Top linkTop

Default URL Reservations

URL reservations are composed of a prefix, host name, port, and virtual directory:

Part

Description

Prefix

The default prefix is HTTP. If you previously installed a Secure Sockets Layer (SSL) certificate, Setup will try to create URL reservations that use the HTTPS prefix.

Host name

The default host name is a strong wildcard (+). It specifies that the report server will accept any HTTP request on the designated port for any host name that resolves to the computer, including http://<computername>/reportserver, https://localhost/reportserver, or http://<IPAddress>/reportserver.

Port

The default port is 80. Note that if you use any port other than port 80, you will have to explicitly add it to the URL when you open a Reporting Services Web application in a browser window.

Virtual directory

By default, virtual directories are created in the format of ReportServer_<instance_name> for the Report Server Web service and Reports_<instance_name> for Report Manager. For the Report Server Web service, the default virtual directory is reportserver. For Report Manager, the default virtual directory is reports.

An example of the complete URL string might be as follows:

  • http://+:80/reportserver, provides access to the report server.

  • http://+:80/reports, provides access to Report Manager.

Arrow icon used with Back to Top linkTop

Install Native Mode with the SQL Server Installation Wizard

The following list describes the Reporting Services specific steps and options you select in the SQL Server Installation Wizard. The list does not described each page you will see in the installation wizard, only the Reporting Services related pages that are part of a Native mode installation.

  1. On the Setup Role page, Select SQL Server Feature Installation.

    SQL Server Feature Installation for setup role

     

  2. On the Feature Selection page, select the following:

    • Database Engine Services, unless an instance of the database engine is already installed.

    • Reporting Services-Native.

    • Management Tools – Basic. The management tools are not required but it is recommended unless you have some other installation of management tools. The default configuration option will result a functioning report sever but you may want to change configuration options at a later date. Some options such as ‘My Reports’ are managed through Management Studio

    SSRS Native Mode Select in Feature Selection

     

  3. If you plan to use the Reporting Services subscription feature, then on the Server Configuration page, you want to verify SQL Server Agent is configured for Automatic Startup type.

  4. On the Reporting Services Configuration page select Install and Configure.

    SSRS Native Mode Configuration

     

  5. After the SQL Server installation wizard is complete, verify the default Native mode installation using the following basic steps.

    • Open Reporting Services Configuration Manager and confirm you can connect to the report server.

    • Open your browser with administrative privileges and connect to Reporting Services Report Manager, for example http://loclahost/Reports.

    • Open your browser with administrative privileges and connect to the Reporting Services report server page. For example, http://loclahost/ReportServer

For more information, see the Native section of the following two topics:

Verify a Reporting Services Installation

Troubleshoot a Reporting Services Installation

Arrow icon used with Back to Top linkTop

Install Native Mode with the Command Line

The following example includes the Database Engine Service because it is required for a default configuration.

setup /q /ACTION=install /FEATURES=SQL,RS,TOOLS /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" 
/RSSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /AGTSVCACCOUNT="NT AUTHORITY\NETWORK 
SERVICE" /RSSVCSTARTUPTYPE="Manual" /RSINSTALLMODE="DefaultNativeMode"

For more information and examples, see Command Prompt Installation of Reporting Services SharePoint Mode and Native Mode and Install SQL Server 2012 from the Command Prompt

Arrow icon used with Back to Top linkTop

See Also

Tasks

Verify a Reporting Services Installation

Reference

Configure Windows Service Accounts and Permissions

Concepts

Troubleshoot a Reporting Services Installation

Configure the Report Server Service Account

Configure Report Server URLs

Configure a Report Server Database Connection (Native Mode)

Files-Only Installation (Reporting Services)

Initialize a Report Server

Configure SSL Connections on a Native Mode Report Server

Configure Report Server URLs

Quick-Start Installation of SQL Server 2012