Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Adding Report Services to existing passive cluster node Expand / Collapse
Author
Message
Posted Wednesday, April 24, 2013 2:06 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, November 16, 2016 9:57 AM
Points: 6,147, Visits: 13,680
A million? that should keep me going for a while. Glad that's sorted

---------------------------------------------------------------------

Post #1446220
Posted Saturday, April 27, 2013 12:36 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, December 1, 2016 9:54 AM
Points: 8,318, Visits: 16,471
Larry Kruse (4/24/2013)
I have a clustered SQL Server 2008 R2 setup.

Node01 = runs an instance of Report Services pointing at a production report services database on the cluster.
Node02 = isn't running a Report Services instance.

The clustered server contains two primary application databases - Production and Staging

The already installed RS instance on Node01 services the production database. I need to setup Reporting Services on Node02 so that it will service the Staging database.

I began rolling through the setup on Node02 this morning but it failed validation saying that this instance was already clustered. I noted that early on in the setup program, it wanted me to choose the instance to install RS onto, but the pull down only listed the cluster name...not the particular Node name(s).

What steps am I going to have to follow to install an RS instance on Node02 that ties to the Staging database? I found a couple of posts in the forum here describing similar but not quite the same circumstances.

I'm new to working with clustered servers, so I'm a little confused about what things I can and can't do while the cluster is running. Can I simply "pause" the Node02 machine and then run the SETUP.exe program? Do I have bring the Node02 resource offline first?

As always, any help any of you can toss my way will be greatly appreciated. Thanks!

Larry

Skipping the rules during setup will allow you to add ssrs instance to existing cluster instance install.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1447229
Posted Saturday, April 27, 2013 3:52 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, November 16, 2016 9:57 AM
Points: 6,147, Visits: 13,680
could you expand on that perry?

---------------------------------------------------------------------

Post #1447243
Posted Saturday, April 27, 2013 7:18 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, December 1, 2016 9:54 AM
Points: 8,318, Visits: 16,471
george sibbald (4/27/2013)
could you expand on that perry?

You run setup with the skip validation rules parameter. Search google you'll find it.

I generally wouldn't recommend it though as using skip rules may void ms support agreement.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1447265
Posted Saturday, April 27, 2013 8:28 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, November 16, 2016 9:57 AM
Points: 6,147, Visits: 13,680
thanks for clarifying, I thought thats what you meant. And that allows you to install RS as part of the default instance on the second node instead of in its own instance?

---------------------------------------------------------------------

Post #1447271
Posted Sunday, September 18, 2016 9:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 29, 2016 3:33 AM
Points: 2, Visits: 23
Hi Everyone,

I am trying to install reporting services in passive node. (SQL Server 2012 failover cluster), through command prompt.
Setup.exe /SkipRules=StandaloneInstall_HasClusteredOrPreparedInstanceCheck /Action=Install.

Everything went fine, but while installating I have received errors and installation got failed.

1)The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2203.

2)The installer has encountered an unexpected error. The error code is 2203. Database: C:\Windows\Installer\inprogressinstallinfo.ipi. Cannot open database file. System error -2147287037.

I am in urgent need, Please guide me how to fix these errors.


Post #1818695
Posted Sunday, September 18, 2016 9:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 29, 2016 3:33 AM
Points: 2, Visits: 23
Hi George,

I am trying to install SSRS in passive node (SQL Server 2012 Failover cluster), through command prompt
Setup.exe /SkipRules=StandaloneInstall_HasClusteredOrPreparedInstanceCheck /Action=Install

Everything went fine, but when installation process is running, I have received couple of errors and installation got failed.

Here are the errors:

1) The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2203.

2) The installer has encountered an unexpected error. The error code is 2203. Database: C:\Windows\Installer\inprogressinstallinfo.ipi. Cannot open database file. System error -2147287037.

Need to fix this ASAP, please guide me how to fix this.
Post #1818696
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse