I'm trying to create a reporting services solution to allow failover to a secondary server should the primary server fail.
I need to get this working (if possible) on SQL server 2005 Standard Edition (SP3). I have configured 2 servers both running reporting service and SQL Database Server.
What I am trying to achieve is this:Server 1
acts as the live server that all users connect to. The SSRS service will be started on this server. Additionally the Report Server database and TempDB reside on the server.Server 2
acts as the backup server. On this server will reside the mirror of the Report Server DB and TempDB. The SSRS service on the machine will be stopped.
In the event of server 1 failing, the database will be failed-over to Server 2 and the SSRS service started. Users then connect to Server 2.The problem
To ensure it can decrypt the information, I have restored the SSRS encryption keys from server1 to Server 2.
I have configured the above and when trying to access the report server I get the message
The feature: "Scale-out deployment" is not supported in this edition of Reporting Services
I've checked the Report server configuration on Server 2 which is showing that the Initilzation is ok. (shows a tick, although I can access the screen as it's we are using stanard edition).
I know this seems to think I am trying to create a scale-out-deployment, but thats not the case. I only want one instance or SSRS to access the DB at a time, not a reporting services webfarm.
Seems a bit silly that this can't be done with standard edition for DR purposes when standard edition supports database mirroring.
Given all of the above..........
1. if I wanted to restore report server database after a server failure, would it allow me to do so if I had to create a fresh build, as it's cleary keeping information about the server / database somewhere?
2. Does anyone know a way I could get around this issue to implement my solution? (and please don't say buy Enterprise edition :-) )
MCITP: Business Intelligence Developer (2005)