Skip to content

Instantly share code, notes, and snippets.

@OsirisDBA
Last active April 13, 2021 21:56
Show Gist options
  • Save OsirisDBA/483259955722870a6b6231beff298bf8 to your computer and use it in GitHub Desktop.
Save OsirisDBA/483259955722870a6b6231beff298bf8 to your computer and use it in GitHub Desktop.
Remotely setting a SQLServerAgent registry value with dbatools help
import-module dbatools
$TargetServer = "MyRemoteComputer"
$regRoot = Get-DbaRegistryRoot -ComputerName $TargetServer
# Reading a key
Invoke-Command -ComputerName $regRoot.ComputerName -ScriptBlock {
param($r)
Get-ItemProperty -Path "$($r.RegistryRoot)\SQLServerAgent" -Name MSXEncryptChannelOptions
} -ArgumentList $regRoot
# Writing a key
Invoke-Command -ComputerName $regRoot.ComputerName -ScriptBlock {
param($r)
Set-ItemProperty -Path "$($r.RegistryRoot)\SQLServerAgent" -Name MSXEncryptChannelOptions -Value 2
} -ArgumentList $regRoot
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment