• Hi Dave,

    Its a wonderful steps you've provided in your article.

    I've been SSRS admin for quite some time. Reading through your article, I was particularly looking for the section where you apply permission scripts from the principal to the DR server but couldnt find it.

    Particularly, I'm referring to RSExecRole being created on the DR. Would switch to DR still work without this database role in msdb?

    Simon

    Simon Liew
    Microsoft Certified Master: SQL Server 2008