Can we change SQL Server Faliover Cluster Service account remotely using Powershell


i have created powershell script change sql server service accounts , working fine on standalone servers. not able change sql server failover cluster service account. bol came know need change sql cluster service account active node of cluster.

powershell code snippet:

[system.reflection.assembly]::loadwithpartialname("microsoft.sqlserver.sqlwmimanagement") | out-null
$wmi = new-object ("microsoft.sqlserver.management.smo.wmi.managedcomputer") $server
$services = $wmi.services | {($_.serviceaccount -eq $oldserviceaccount)  | foreach{$_.setserviceaccount($newserviceaccount,$password)}

i copied script active node , run active node script works perfectly. tried calling script in active node of invoke-command local, failed.

in environment have 100 clusters, be difficult ts active node of each cluster , execute script. there way in powershell run service account change script on sql failover clusters remotely?

has tried configuring sql server facets properties using powershell... tried below code..and able find out properties of facets not getting idea on how set values these properties.

  [system.reflection.assembly]::loadwithpartialname('microsoft.sqlserver.dmf') | out-null  [system.reflection.assembly]::loadwithpartialnam('microsoft.sqlserver.management.sdk.sfc') | out-null  $conn = new-object microsoft.sqlserver.management.sdk.sfc.sqlstoreconnection("server='ramu-pc';trusted_connection=true")  $policystore = new-object microsoft.sqlserver.management.dmf.policystore($conn)  $facets = [microsoft.sqlserver.management.dmf.policystore]::facets | {$_.name -eq 'isurfaceareafacet'}   $facets | format-table –auto  

when execute below command, see different methods not getting on how user methods.

$facets | gm

i need set below properties of surfacearea configuration facet.

adhocremotequeriesenabled = true

xp_cmdshell = true



Windows Server  >  Windows PowerShell



Comments

Popular posts from this blog

some help on Event 540

WMI Repository 4GB limit - Win 2003 Ent Question

Event ID 1302 (error 1307) DFS replication service encountered an error while writing to the debug log file