RDS 2012 SQL AlwaysOn Considerations

The use of SQL Server 2012 Availability Groups in conjunction with RDS 2012 I  have had a few questions on RDCB HA recently so I have provided some useful information on deployments and best practices when using SQL 2012 AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups. The RD Connection Broker role is what controls the RDS Deployment... Continue Reading →

PowerShell Script for SQL Firewall rules

As Netsh Firewall commands are now deprecated , I have written a PowerShell script for use with deploying SQL or accessing remote instances.   Set-ExecutionPolicy -ExecutionPolicy RemoteSigned  #Enabling SQL Server Ports New-NetFirewallRule -DisplayName “SQL Server” -Direction Inbound –Protocol TCP –LocalPort 1433 -Action allow New-NetFirewallRule -DisplayName “SQL Admin Connection” -Direction Inbound –Protocol TCP –LocalPort 1434 -Action allow... Continue Reading →

Troubles with Removing RD Connection Broker High Availability

I thought it would be a good Idea to include a post that provides information on the troubles caused by removing a RD Connection Broker Availability configuration. Once a RD Connection Broker HA configuration is installed, you cannot revert back to the windows internal Database with out decommissioning  the whole RDS configuration. When you add... Continue Reading →

Configure SQL for RDS 2012

Installing SQL for RDS 2012 - RD HA Mode For this example i am using SQL Express 2012 and a single instance. For more information on high available SQL Solutions please see the following link: http://msdn.microsoft.com/en-us/library/ms190202.aspx  you can set a Service account, for this example i have used the defaults. Enter the User names that can... Continue Reading →

MSSQL Firewall Script

I came across a very useful SQL Script the other day that saves you the hassle of playing round with Windows Firewall. @echo =========  SQL Server Ports  =================== @echo Enabling SQLServer default instance port 1433 netsh firewall set portopening TCP 1433 "SQLServer" @echo Enabling Dedicated Admin Connection port 1434 netsh firewall set portopening TCP 1434... Continue Reading →

Deploying System Center 2012 Data Protection Manager

Data Protection Manager 2012 is part of Microsoft System Center 2012 Stack and is designed to help business's to manage their IT infrastructure. Data Protection Manager is a hybrid data replication and archival product that uses features found in common backup products to provide centralised management for Microsoft-based Servers/End-user workstations. Data Protection Manager Provides disk-to-disk, disk-to-tape, and disk-to-disk-to-cloud data... Continue Reading →

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: