Link to home
Start Free TrialLog in
Avatar of cmatchett
cmatchettFlag for United Kingdom of Great Britain and Northern Ireland

asked on

adding cluster resource to sql server

hey experts,

In Windows server 2012, you can use the following cmdlet

Set-ClusterParameter -Multiple @{"Network"="My Backup";"EnableDHCP"=1}

In Windows server 2008 R2, the multiple parameter is not available.

Can you assist me In understanding how to set the parameters above in server 2008 r2?
Avatar of cmatchett
cmatchett
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

$res = Get-ClusterResource -Name 'New IP Address' | Get-ClusterParameter
$parameter1 = New-Object Microsoft.FailoverClusters.PowerShell.ClusterParameter $res,Address,192.168.11.10
$parameter2 = New-Object Microsoft.FailoverClusters.PowerShell.ClusterParameter $res,SubnetMask,255.255.255.0
$parameterList = $parameter1,$parameter2
      $parameterList
$parameterList | Set-ClusterParameter

Then i get the following

Object                                  Name                                    Value                                  Type                                  
------                                  ----                                    -----                                  ----                                  
New IP Address                          Address                                 192.168.10.10                          String                                
New IP Address                          SubnetMask                              255.255.255.0                          String                                
Set-ClusterParameter : Unable to save property changes for 'New IP Address'.
At line:8 char:18
+ $parameterList | Set-ClusterParameter
+                  ~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Set-ClusterParameter], ApplicationException
    + FullyQualifiedErrorId : System.ApplicationException,Microsoft.FailoverClusters.PowerShell.SetClusterParameterCommand
so this works

$res = Get-ClusterResource –Name "New IP Address (1)"
     
$param1 = New-Object Microsoft.FailoverClusters.PowerShell.ClusterParameter $res,network,'Cluster Network 1'
   
$param2 = New-Object Microsoft.FailoverClusters.PowerShell.ClusterParameter $res,Address,192.168.0.92
     
$params = $param1,$param2

$params
     
$params | Set-ClusterParameter

I am unable to set dhcp on this cluster resource - it is greyed out.

Any ideas why?
Avatar of Vitor Montalvão
I've removed the SQL related topics and added Windows Server topic areas to attract the right Experts.
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial