Sample-SQL-Actions demonstrates how to create a SQL database connection and use this connection to execute commands on the database through SMA in Windows Azure Pack. Before running this workflow, you must create a Management Service (Windows Azure Pack) variable named ‘SQL_Connectionstring’ with the connectionstring to the SQL server. Example: “Server=SQL1;Database=TestDB;User ID=SQLuser;Password=Passw0rd;” http://gallery.technet.microsoft.com/scriptcenter/SMA-Sample-SQL-Actions-9cdfefa4 <# Sample-SQL-Actions […]
Tag: System Center
No Run As account is associated with the host.
Error (26193) No Run As account is associated with the host. Recommended Action You have not specified a Run As account for your host. You can add a Run As account to the cluster using Powershell: $Cluster = Get-SCVMHostCluster -Name CLUSTER_NAME $RunAs = Get-SCRunAsAccount -Name "RUN_AS_ACCOUNT" Set-SCVmHostCluster -VMHostCluster $Cluster -VMHostManagementCredential $RunAs
VM Network Wizard fails with errorcode 12416
I found a bug in the creation of VM networks. I received the error: VMM is unable to process one of the provided parameters for the cmdlet (New-SCVMSubnet): Cannot convert ‘System.Object[]’ to the type ‘Microsoft.SystemCenter.VirtualMachineManager.LogicalNetworkDefinition’ required by parameter ‘LogicalNetworkDefinition’. Specified method is not supported ID: 12416 I created a Network site called “ABC” on my […]
Set custom property’s on VM creation
It seems like you cant set custom property’s on VM creation, you will encounter these problems if you use a powershell function to deploy a VM like below and you want to set a custom property in the same function. Function CreateVM { #Create unique Guid as JobGroupID $JobGroupID = [Guid]::NewGuid().ToString() $VMTemplate = Get-SCVMTemplate | […]
VMM Crash – Error 802
Encountered some strange behaviour within VMM. Situation: I created a VM Template “VMTemplate – Windows Server 2012 Datacenter” from a server called “VM – Windows Server 2012 Datacenter”. The VM Template disk is stored in a folder on the library share. When I delete the folder (or safely move to a folder outside the library) […]
Force Remove Virtual Machine Manager library
There is no Remove-SCLibraryServer -Force command but you can still delete a non-existent VMM Library Server. First open up the SQL Management studio and execute the following query to find out your VMM Library server ID: use VirtualManagerDB go select LibraryID, ComputerName from dbo.tbl_ADHC_Library You’ll see an ID similar to the one below. Next, remove […]