Hi,

I need to automate the backup of the encryption key of SSRS with Powershell.  I tried wrapping the application rskymgmt with no success.  Then I found out that you could do it with the WMI class as mention here: http://msdn.microsoft.com/en-us/library/ms155048(v=SQL.100).aspx#CommunityContent.  How would I do that in Powershell, all my attempts have failed!

thx in advance.

Hi Eric,

We can use the following PowerShell script to backup the encryption key:

Write-Output "Backup encryption key file"
 $serverClass = get-wmiobject -namespace "root\microsoft\sqlserver\reportserver\rs_mssqlserver\v10\admin" -class "MSReportServer_ConfigurationSetting" 
if ($serverClass -eq $null) { throw "Cannot find wmi class" }
$password = "Password01!"
$keyFile = $null
$length = 0
$HRESULT = 0
$extendedErrors = $null

$result = $serverClass.BackupEncryptionKey("Password01!")

$stream = [System.IO.File]::Create("c:\\ssrs.snk", $result.KeyFile.Length);
        
$stream.Write($result.KeyFile, 0, $result.KeyFile.Length);
        
$stream.Close();

If you have any more questions, please feel free to ask.

Thanks,
Ji

Hello,

I've tried this code and doesnt work :(.

Hi,

When I run:

$serverClass = get-wmiobject -namespace "root\microsoft\sqlserver\reportserver\rs_mssqlserver\v10\admin" -class "MSReportServer_ConfigurationSetting" 

I got a message:

get-wmiobject :
At line:1 char:16
+ $serverClass = get-wmiobject -namespace "root\microsoft\sqlserver\reportserver\r ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Get-WmiObject], COMException
    + FullyQualifiedErrorId : GetWMICOMException,Microsoft.PowerShell.Commands.GetWmiObjectCommand

What can cause this problem?