-
Use SMA Complex Type asset to store product keys in encrypted form
I’m working on a project were we install SQL on VMs via an SMA runbook. The runbook generates a configuration.ini and then kicks of a scripted install. We support SQL 2008R2 Standard and Enterprise and SQL 2012 Standard and Enterprise. …
-
SMA Database purge job and SQL AlwaysOn AG
As part of the SMA installation, a SQL job gets created which runs a stored procedure to purge old SMA jobs from the database every 15 minutes by default. See http://technet.microsoft.com/en-us/library/dn469633.aspx for more information. When you use SQL AlwaysOn AG for your SMA database this job should be created on the “secondary” node as well to make sure it runs no matter which node is acting as Active. …
-
SCVMM 2012 R2 UR4, move host group assigned services to a cloud (The supported way)!
A while back I posted an item about how to move VMM services (deployed instances of service templates) from host groups to clouds in an unsupported way using some tsql against the VMM database. A link to this post can be found here: http://wp.me/p1COfr-H Last week I received a comment on this post by David Padley who took my idea and constructed a PowerShell module around it. This script can be found here: https://onedrive.live.com/redir?resid=3064018F27C72ECC%21113 …
-
Losing UDP traffic in a Hyper-V environment with NVGRE and can't explain why?
I was working on a project where I had to setup Hybrid connectivity. NVGRE isolated tenant network connected up to an Azure vNET using IPSEC VPN over a HNV gateway. Awesome stuff :-) …
-
WAPack hoster intercepts tenant user provided local admin credentials during VM role deployment (fixed in UR4)
I started this proof of concept because I was testing the integration capabilities of SMA with WAPack. During my initial investigation I found this blog post by Michael Rueefli which saved me a lot of work. …