Archive

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):

https://msdn.microsoft.com/en-us/library/ms159106.aspx

 

Rsconfig,exe:

http://msdn.microsoft.com/en-us/library/ms162837.aspx

Installing Reporting Services from the Command Prompt:

http://msdn.microsoft.com/en-us/library/ms144272(SQL.90).aspx

Reporting Services WMI Provider:

http://msdn.microsoft.com/en-us/library/ms152836(SQL.90).aspx

Report Server Web Service Endpoints:

https://msdn.microsoft.com/en-us/library/ms155398.aspx

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

https://msdn.microsoft.com/en-us/library/dn531017.aspx

Script Deployment and Administrative Tasks:

https://msdn.microsoft.com/en-us/library/ms159720.aspx

RsReportServer.config Configuration File:

https://msdn.microsoft.com/en-us/library/ms157273.aspx

ReportingServicesService Configuration File:

https://msdn.microsoft.com/en-us/library/ms156479.aspx

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

https://msdn.microsoft.com/en-us/library/bb630448.aspx

Reporting Services Extensions:

https://msdn.microsoft.com/en-us/library/ms152934.aspx

Report Server Web Service:

https://msdn.microsoft.com/en-us/library/ms152787.aspx

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