Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Chapter 22Server Administration

WHAT'S IN THIS CHAPTER?

• Enforcing security
• Account management and system-level roles
• Implementing surface area management
• Planning for backup and recovery
• Managing application databases
• Managing encryption keys
• Using configuration files
• Monitoring and logging
• Using performance counters and server management reports
• Understanding memory management
• Configuring URL reservations
• Administering e-mail delivery
• Managing rendering extensions

With any mission-critical service, it is important to properly configure and administer your report server. If you have Reporting Services configured in Native mode and not integrated into SharePoint, you will use tools that are specific to Reporting Services.

NOTE

In previous editions of this book, we provided some guidance and high-level configuration information for SharePoint integration. Now that SSRS integration with SharePoint is managed entirely within SharePoint, this is a topic that falls squarely within the discipline of SharePoint site planning and administration. For the Reporting Services administrator, this means that after Reporting Services is installed in SharePoint Integrated mode, service management, content management, and security is all managed within SharePoint.

This chapter addresses the administration tasks for a report server configured in Native mode. It does not apply to SharePoint Integrated mode. The integrated report server is managed completely within the SharePoint Central ...