Need help?

Our experts have had an average response time of 11.7 minutes in August 2021 to fix urgent issues.

We will keep your servers stable, secure, and fast at all times for one fixed price.

How to setup reporting services configuration manager?

by | Feb 23, 2021

Wondering how to setup reporting services configuration manager? We can help you.

Recently we had a customer who sought advice to setup SQL Server Reporting Services (SSRS), a server-based report generating software system.

We can use it to prepare and deliver a variety of interactive and printable reports with less effort.

Instead of writing code, we can drag-and-drop graphic icons into an SSRS report format.

As part of our Server Management Services, we assist our customers with several SQL queries.

Today, let us see how our Support Techs setup reporting services configuration manager

 

Reporting Services Configuration Manager

The Reporting Services Configuration Manager can configure the Reporting Services installation if it is set to ‘Native Mode’.

However, if Reporting Services is installed in ‘Integrated Mode’ it needs to configure in Microsoft SharePoint.

We use the Configuration Manager to configure the Report Server service account, create and configure the report server database, create and configure the Report Manager and Report Server URLs, configure server mail settings, etc.

If we install a report server using the files-only installation option, we must use the Configuration Manager to configure the server before use.

If we install a report server using the default configuration installation option, we can use the Configuration Manager to verify or modify the settings specified during setup.

In addition, we can use it to configure a local or remote report server instance.

 

Scenarios to use Reporting Services Configuration Manager

Our Support Techs suggest we can use the Reporting Services Configuration Manager to perform the following tasks:

  • Configure the Report Server service account

We configure the account initially during setup. We can modify them using the Reporting Services Configuration Manager if we update the password or want to use a different account.

  • Create and configure URLs

The report server URL provides access to the SOAP endpoints of the report server. We can configure a single URL or multiple URLs for each application.

  • Create and configure the report server database

We can use it to create and configure a connection to the report server database. In addition, we can select an existing report server database that already contains the content we want to use.

  • Configure a Native mode scale-out deployment

Reporting Services supports a deployment topology that allows multiple report server instances to use a single, shared report server database.

  • Backup, restore, or replace the symmetric key

We can use it to backup, restore, or replace the symmetric key used to encrypt stored connection strings and credentials.

  • Configure the unattended execution account

This account is for remote connections during scheduled operations or when user credentials are not available.

  • Configure report server e-mail

It includes a report server e-mail delivery extension that uses an SMTP to deliver reports or report processing notifications to an electronic mailbox. We can specify the SMTP server or gateway on the network to use for e-mail delivery.

 

How to setup reporting services configuration manager?

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

In order to use it, our Support Engineers suggest having:

  • Local system administrator permissions on the computer that hosts the report server we want to configure.
  • Permission to create databases on the SQL Server Database Engine.
  • Windows Management Instrumentation (WMI) service must be enabled and running on any report server we configure.
  • Enable remote WMI calls to pass through Windows Firewall.

The Reporting Services Configuration Manager installs automatically when we install SQL Server Reporting Services.

 

Reporting Services Configuration Manager (Native Mode)

We use the Native mode configuration manager to complete the following:

  1. Specify the service account.
  2. Create or upgrade the report server database.
  3. Modify the connection properties.
  4. Specify URLs.
  5. Manage encryption keys.
  6. Configure unattended report processing and e-mail report delivery.

Reporting Services Configuration Manager is installed when we install Reporting Services Native mode.

  • Start the Reporting Services Configuration Manager

Search for Reporting in the Windows start screen, in the results, click Reporting Services Configuration Manager.

Or

Click Start >> Programs >> Microsoft SQL Server >> Configuration Tools >> Reporting Services Configuration Manager.

Eventually, the Report Server Installation Instance Selection dialog box appears and we can select the report server instance we want to configure.

In Server Name, specify the name of the computer on which the report server instance is installed.

If we specify a remote computer, click Find to establish a connection. The report server must configure for remote administration in advance.

In Instance Name, choose the SQL Server Reporting Services instance to configure.

Then click Connect.

Finally, verify that we launched the tool.

 

Web Portal (Native Mode)

The web portal (SSRS Native Mode) is to set permissions, manage subscriptions and schedules, and work with reports.

The installation is done when we install Reporting Services Native mode.

Before we can open the Web Portal, we must have sufficient permissions.

Users who have no permissions will get an empty page. Users with permissions to view reports will get links that they can click to open the reports.

  • Start The Web Portal

Initially, open a browser.

Then in the address bar of the Web browser, we type the Web Portal URL. By default, the URL is https://<serverName>/reports.

Eventually, the Web Portal opens in the browser window. The startup page is the Home folder.

Depending on permissions, we might see additional folders, hyperlinks to reports, and resource files within the startup page.

 

Management Studio

Report server administrators can use Management Studio to manage a report server alongside other SQL Server component servers.

  • Start SQL Server Management Studio

From the Windows Start Screen type SQL server and from the results, click SQL Server Management Studio.

Or

Click Start >> All Programs >> Microsoft SQL Server >> SQL Server Management Studio. Eventually, the Connect to Server dialog box appears.

However, if the dialog box does not appear, in Object Explorer, click Connect and then select Reporting Services.

Then in the Server type list, select Reporting Services.

In the Server name list, select a report server instance. Local instances appear in the list. We can also type the name of a remote SQL Server instance.

Finally, click Connect. In addition, we can expand the root node to set server properties, modify role definitions, or turn off report server features.

[Stuk with the setup? We’d be happy to assist]

 

Conclusion

To conclude, if you are wondering how to setup reporting services configuration manager, this article gives you an elaborate idea on the same. Today, we saw how our Support Techs perform the task.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = "owonCMyG5nEQ0aD71QM";

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF