Posts Tagged ‘SQL 2008 R2’

Prepare now for end of support in 2019 and 2020 (updated April 1, 2019)

Calling all Windows Server 2008 R2 users. The End is Nigh

Announcing new options for SQL Server 2008 and Windows Server 2008 End of Support

•Extended Support for SQL Server 2008 and 2008 R2 will end on July 9, 2019.
•Extended Support for Windows Server 2008 and 2008 R2 will end on January 14, 2020.

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