Archive

Posts Tagged ‘SQL 2008 R2’

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

https://azure.microsoft.com/en-us/blog/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):

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