Imagine you have installed and initialized SSRS in your Primary
and DR Environment and To Mirror the DR environment to the Primary SSRS follow the
below steps,
- Copy the ReportServer and ReportServerTempDB to the DR Server
Note:- If you just do the database restore and
try to access the SSRS you get the error “The report
server installation is not initialized. (rsReportServerNotActivate d)”, You
need to follow the below steps to configure the DR SSRS with the existing
database.
2.Backup
Encryption Key for the Primary SSRS
3. Copy
the Encryption Key File to DR SSRS Server, In my case say C:\Test\ssrsencryptkey.snk
4. Run
the following Query in ReportServer database of the DR server
'DELETE FROM [Dbo].[Keys] WHERE client > -1'
5. Now
search for Program Files folder for “RSKeymgmt.exe”
in DR Server
6. Execute
the "RSKeymgmt.exe" from command
Prompt of DR Server in Admin context with the below syntax,
RSKeymgmt.exe -a -f "C:\Test\ssrsencryptkey.snk"
-p "<passwordof theencryptionkey>"
7. Restart SSRS.
7. Restart SSRS.
Once you have
completed these steps you access the Reports web page for the DR SSRS it should
match the primary server. Remember I have not configured any real time DR for
the ReportServer and ReportServerTempDB databases in the above example, You
have to set up Logshipping/Mirroring for the SSRS databases for complete DR
Solution. The above steps merely explains how to configure in case of failover.The
same set of steps can be used if you want to copy SSRS across different servers.
Hope the article helps.
This comment has been removed by a blog administrator.
ReplyDelete>>Hope the article helps. Yes it did, Vinoth. Thank you!
ReplyDeleteThanks for this Vinoth. Does this needs to be done only once? Or for every failover? Because I saw in another forum that a user created a job to do this task automatically when the report server databases fail over to DR. Thanks.
ReplyDeleteGreat! Thank you. It helped a lot :)
ReplyDeletereplica rolex orologi, combining elegant style and cutting-edge technology, a variety of styles of replica rolex gmt master ii orologi, the pointer walks between your exclusive taste style.
ReplyDeleteHi there! Nice stuff, do keep me posted when you post again something like this! csgo high tier accounts
ReplyDeletePretty nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. After all I’ll be subscribing to your feed and I hope you write again soon! pubg mobile accounts
ReplyDeleteTODAY I GOT MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY. IF YOU NEED A LOAN NOW EMAIL CONTACT drbenjaminfinance@gmail.com
ReplyDeleteHello, I'm here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr. Benjamin Owen he holds all of the information about how to obtain money quickly and painlessly without cost/stress via Email: drbenjaminfinance@gmail.com
Consider all your financial problems tackled and solved ASAP. Share this to help a soul right now THANKS.