Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dkohnken
Starting Member
2 Posts |
 Posted - 2009-12-30 : 13:52:32
|
| I have installed SQL 2008 Standard on two servers running Server 2003 Enterprise R2 SP2, which are clustered for failover.I have configured Reporting Services on the one server and it works fine, I can access the URL for both the Report Server DB and the Report Manager. I used the SQL Virtual name to configure the Reporting Services.I configured the other with the exact same paramaters, virtual SQL name, and when I move the group to the failover server, I cannot access either the report Server DB or the Manager. I am assuming this is because of the Decrypt and Encrypt key used.Reading some of the articles, it seems that a Scale-Out Deplyment is only supported on the Enterprise edition of SQL 2008. Enterprise support multipe Encrypt and Decrypt keys. Is this correct? The next question, can I install a single instance of SQL 2008 Report Services on an IIS Server, creating the Virtual Directory pointing to the SQL 2008 Shared disk used by both failover servers for the Report Server Databases. My thought here is, only one instance of Report Services, meaning only one Decrypt and Encrypt key, which should work for SQL Standard.Of course this means a single point of failure for Reporting Services. Will this work?Thank you in advance for your help. |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2010-01-20 : 08:54:01
|
| Did you add the clustered server in the Reporting Server Farm in the SQL server Reporting Services Configuration Managerhttp://www.sqlserver007.com |
 |
|
|
|
|
|
Configuring Report Services in a Clustered Environ