Configuring SRS Reporting on a clustered SQL server...

[MRaybone]

Hi all,

 

I have the following boxes configured, simplified for easier reading:

 

SCCM 2007 R2 SP2 box... SCCM01

Clustered SQL 2008... CLUS01 and CLUS02

The SQL instance I've been given is SQL01\SCCM

 

Now, if I want to get SRS running, I need to install the Site System onto the SQL boxes themselves. In the SCCM console under Site Systems, my SQL instance appears not as the named instance (SQL01\SCCM) which I provided at installation, but as the 2 individual SQL cluster servers (CLUS01 & CLUS02). My question is, do I pick one, or both, of these and install the SRS Site System, or do I 'Add New Server' and add in the named instance (SQL01) instead?

 

Cheers,

MRaybone.

[wmmayms]

Hi all,

 

I have the following boxes configured, simplified for easier reading:

 

SCCM 2007 R2 SP2 box... SCCM01

Clustered SQL 2008... CLUS01 and CLUS02

The SQL instance I've been given is SQL01\SCCM

 

Now, if I want to get SRS running, I need to install the Site System onto the SQL boxes themselves. In the SCCM console under Site Systems, my SQL instance appears not as the named instance (SQL01\SCCM) which I provided at installation, but as the 2 individual SQL cluster servers (CLUS01 & CLUS02). My question is, do I pick one, or both, of these and install the SRS Site System, or do I 'Add New Server' and add in the named instance (SQL01) instead?

 

Cheers,

MRaybone.

 

 

Im not 100% sure but since i havent done this...but i would definatly try to install onto the virtual instance.

[jamitupya]

Reporting services is not cluster aware as yet afaik.... a quick search on MS came back with this by Ross Mistry

 

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/fa723b21-ef90-4109-bb53-b48cc000a821

 

 

We have generally a separate reporting box for this with a replica DB, its not perfect, but works for us