Configuring SSRS servers

Some things in SSRS can only be configured using Windows Management Instrumentation (WMI). Tasks that can give effective control over the operating system that is running Sql Server Reporting Services should, after all, require local admin privileges on the machine being configured.

These commands are primarily required for configuring system integration of the Reporting Services, and are usually used during initial deployment or after infrastructure changes.

One of the most basic commands is Set-RsDatabase, with which SSRS configures what database will be hosting its operating data, which often is set to the local instance, but may well be run on any SQL Instance:

# Setting up localhost
$paramSetRsDatabase = @{
DatabaseServerName = 'localhost'
Name = 'ReportServer'
DatabaseCredentialType = 'ServiceAccount'
}
Set-RsDatabase @paramSetRsDatabase

# Connecting to an existing database with custom credentials
$paramSetRsDatabase = @{
DatabaseServerName = 'sql2017'
Name = 'ExistingReportServer'
IsExistingDatabase = $true
DatabaseCredentialType = 'Windows'
DatabaseCredential = $myCredentials
}
Set-RsDatabase @paramSetRsDatabase

After establishing the database connection, it's time to configure the URLs through which the Reporting Services should be reached. Look to Set-RsUrlReservation for all your URL configuration needs:

# Set up with default paths
Set-RsUrlReservation

# Set up with special names and ports
$paramSetRsUrlReservation = @{
ReportServerVirtualDirectory = 'ReportServer2017'
PortalVirtualDirectory = 'Reports2017'
ListeningPort = 8080
}
Set-RsUrlReservation @paramSetRsUrlReservation
Note that the portal virtual directory is the path you later use for REST API calls, while the RS Virtual Directory is for webservice calls.

Once the database is set and the URLs are ready, it's time to launch the Reporting Services:

Initialize-Rs

No further voodoo needed.

Other useful admin tools include setting up email services (Set-RsEmailSettings), managing encryption keys (Backup-RsEncryptionKey and Restore-RsEncryptionKey, both quite handy when migrating the Reporting Service), or integration into PowerBI (Register-RsPowerBI).

For more information on ReportingServicesTools, see their public GitHub repository: https://github.com/Microsoft/ReportingServicesTools
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset