Posts Tagged ‘SQL 2008 R2’

Improved AlwaysOn Availability Group Lease Timeout Diagnostics

TLS 1.2 Support for SQL Server 2008, 2008 R2, 2012 and 2014 (KB3135244)

SSRS: How do I automate the deployment of an SSRS 2014 server?

September 10, 2015 Leave a comment

Reporting services exposes a WMI interface that can be scripted via powershell or other scripting provider I believe there is also a way to achieve some of this via the commandline and rsconfig.exe

The Report Server WMI provider exposes classes, properties, and methods that allow you to configure all aspects of a Reporting Services installation including specifying service accounts, configuring virtual directories, creating and configuring the report server database, or configuring a report server for e-mail delivery.

For more information:

Reporting Services (SSRS):



Installing Reporting Services from the Command Prompt:

Reporting Services WMI Provider:

Report Server Web Service Endpoints:

Sample Reporting Services rs.exe Script to Copy Content between Report Servers:

Script Deployment and Administrative Tasks:

RsReportServer.config Configuration File:

ReportingServicesService Configuration File:

Modify a Reporting Services Configuration File (RSreportserver.config):

Reporting Services Extensions:

Report Server Web Service:

AX 2012: Announcing support for SQL Server 2008 R2 Service Pack 3

SQL Updates Newsletter – February 2015

Running SQL Server on Machines with More Than 8 CPUs per NUMA Node May Need Trace Flag 8048

Index Rebuild Enhancements with Newer SQL Versions