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 →

Deploying RD Connection Broker High Availability in Windows Server 2012

Prerequisite Configuration Create a folder on the root directory of the SQL Server ("DB_path") "if a local path is used" (on the SQL Server). Ensure that all RDS servers are added to the Server pool. Before deploying a RD Connection broker HA configuration, Please see the following post: Troubles with Removing RD Connection Broker High Availability RDCB... Continue Reading →

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: