• there are a few things you need to do to use a single address such as http://LiveRS.domain.net/Reports working.

    1 - both the servers will need to have a fixed IP address.

    2 - you need to install dnscmd (if it's not already installed on the servers)

    3 - You will need to amend Reporting Services – Activate RS

    to include an additional 'Operating System (CmdExec) job step to add a DNS entry for the server that you would be switching live, eg sqltest01 might need:

    dnscmd DNSServer.domain.net /RecordAdd domain.net LiveRS 60 A 192.168.10.1

    and sql test02:

    dnscmd DNSServer.domain.net /RecordAdd domain.net LiveRS 60 A 192.168.10.2

    Also, on each respective server for the Reporting Services Switch Live – Maintenance and Reporting Services Force Live – DR add a job step to remove the dns entry for the server that was live and is now becoming the standy / mirror or has become unavailable.

    so sqltest01 would be:

    dnscmd DNSServer.domain.net /RecordDelete domain.net LiveRS 60 A 192.168.10.2 /f

    and sql test02:

    dnscmd DNSServer.domain.net /RecordDelete domain.net LiveRS 60 A 192.168.10.1 /f

    4 - you'll have to setup host headers on the SSRS sites. (we tend to set up both the server name as a host header, i.e. sqltest01.domain.net and also the live references you want to use i.e. http://LiveRS.domain.net/Reports.

    5 - Then you will have the unenviable task of setting up Kerberos authentication.:-P (this is likely to frustrate the hell out of you, if you haven't done this before, as there are lots of 'moving parts'). In breif, you'll need to setup SPN's for SQL Server and http service (for RS) and trust the servers....

    it's better explained in the following locations:

    Configuring Kerberos Authentication - http://www.sqlservercentral.com/articles/Security/65169/

    Kerberos, Delegation and SQL Reporting Services - http://callumhibbert.blogspot.com/search?q=kerberos+delegation

    Troubleshooting Kerberos Delegation (Very useful article)- www.microsoft.com/DownLoads/details.aspx?FamilyID=99b0f94f-e28a-4726-bffe-2f64ae2f59a2&displaylang=en

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)