This is my second post in a series that will discus SQL Report Server from an administrator standpoint. I hope to show you how to work with SSRS, how to configure your instance and what to look for when troubleshooting. None of my posts will talk about report design (except some general tips), SharePoint mode, or scale out installations. Part 1 walked through a default setup using native mode.
Before we start discussing how to configure a report server lets look at what is installed when you choose the native mode default configuration.
Report Server service
This is just as it sounds, the actual SSRS service which processes report requests. It also includes the Report Manager and Report Service web services for managing your reports and the URL address for both. A Network Service account is created that the SSRS service runs under, but you can change this later.
I mentioned in my first post that SQL will install 2 databases. The first is the ReportServer database, where SSRS stores the reports files. You’ll also see report subscriptions, snapshots, report history, encrypted keys, and other server settings.
The second database is called ReportServerTempDB. The session data is stored here, as well as cached reports and other temporary objects.
We’ll talk much more about these reports when discussing server performance.
The Reporting Services Configuration Manager is the pretty GUI way to make configuration changes. If you chose the Install and Configure option when installing SSRS it will be configured with all the defaults. But you can still come here to make changes, or just to see what those defaults are. I’ll cover using the Config Manager in Part 3.
SSRS also installs three command line tools to help deploy reports and manage your server. Use rs.exe to deploy reports to the report mananger. rsconfig.exe encrypts and stores account information in the RSConfig file, and rskeymgmt,exe is used to manage the encryption key. I’ll cover these utilities when I talk about configuration.
I haven’t mentioned any of the tools for designing reports since this series is only covering the administration side of SSRS.
In the next post we will walk through using the Report Server Configuration Manager.
Install Reporting Services Native Mode Report Server (SSRS)
Reporting Service Tools