Post reply

SQL server 2012 SP3 Reporting services when restore databases and encryption keys , Datasource username password connection string is lost/empty.

  • June 14, 2018 at 10:48 am

    #355322

    I have a SQL 2012 SP3 server in prod and Loghipping is configured for reportserver and ReportserverTempdb databases as a DR strategy. When i performed the failover manually to DR server, i have performed below steps and found that the shared datasource connection string is empty after the recoverability on DR server. But i can see the reports on the DR server after the restore. Want to know if i am doing anything wrong. below are the steps performed.

    1. Restore database ReportServer with recovery
    2. Restore Database Reportservertempdb with recovery.
    3. Connect to reporting configuration manager on DR server - connect to databases and restore Production server encryption key.
    4. So when i see the reports on DR server in the shared data sources the connection string is empty. 

    Does any one had same issue?

  • June 22, 2018 at 1:11 pm

    #1995014

    This sounds strange.  Restoring the encryption key should do the trick.  Are you sure you have the correct key?  Maybe export it from the production server just to make sure you have the correct key.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply