I thought it would help to collate all my current RDS posts onto one to make it easier for you tech's to find things. I will add new links to this post when i publish new articles. Deploying RDS 2012 Single Server – Session Based deployment Deploying RDS 2012 using Standard Deployment Creating a Remote Desktop Session... Continue Reading →
Load Balance a SharePoint 2013 Farm in Azure using KEMP
There are a lot of organisations out there like Toyota using SharePoint in Azure. KEMP are the first vendor to offer a layer 7 (application) load balancing product on Azure. I will be showing you how to Load Balance a SharePoint 2013 workload in Windows Azure using KEMP's Azure VLM. KEMP's VLM offers more features than the default Azure Load balancing solution. Please... Continue Reading →
Create A MSA Group Using PowerShell – Server 2012
For those who are struggling to create service accounts: Open PowerShell Import-Module Activedirectory Create the Service Account: New-ADServiceAccount -name <Service Account Name> -Enabled $true -DNSHostName <Service Account Name>.domain.com -PrincipalsAllowedToRetrieveManagedPassword "<Group or Computer>" Example: New-ADServiceAccount -name MSA1 -Enabled $true -DNSHostName MSA1.domain.com -PrincipalsAllowedToRetrieveManagedPassword "Sql Server Group" Add computer to service account: Add-ADComputerServiceAccount -Identity <Servername> -ServiceAccount <Service Account Name>$ Example: Add-ADComputerServiceAccount -Identity SQL1 -ServiceAccount MSA1$... 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 →
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 →
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 →
SQL Server Configuration Manager 2008 R2 – Cannot connect to WMI provider – Invalid class [0x80041010
I came across the following error after restarting my System Center Cluster. Run the following command to fix this: mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"