Automating SQL Reporting-Services (SSRS) Encryption-Key backups using RSKeyMgmt utility
-
I would like to automate the backups of SSRS encryption keys in my environment and have been looking at the RSKeyMgmt command-line utility for this purpose.
I'm executing the following line in the command prompt of the server that hosts the SSRS instance:
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\RSKeyMgmt.exe" -e -i <my_instance_name> -f "<path>\SSRS_encryption_key.bak" -P "<key_passwd"
However, I am being asked this (annoying question) when I press enter, so I'm not sure now how to automate this backup as a job:
Are you sure you want to extract the key from the report server? Yes (Y)/ No (N):
How can I get rid of this question!?!
Has anyone tried this before?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url] -
Edogg (2/23/2010)
Stumbled across this link a while ago, it's a handy little trick.http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8976dd8f-44a8-4fb7-b3ac-05b06f33f9f1/[/url]
Thanks! That'll work...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply