dbTalk Databases Forums  

Installing Reporting services on a cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Installing Reporting services on a cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sheethal
 
Posts: n/a

Default Installing Reporting services on a cluster - 11-20-2009 , 09:12 PM






Hi,

We have an existing production clustered SQL server with a default instance
and a named instance. I need to configure Reporting services on the named
instance but am getting the error "Existing cluster or cluster prepared
instance failed".

Has anyone installed RS on a SQL cluster, can you please give me some steps?

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Installing Reporting services on a cluster - 11-23-2009 , 09:42 AM






It is not a good idea to install RS on a cluster. In fact, it is a very bad
idea.

You cannot install a clustered RS instance, you have to install each node
independently.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Sheethal" <Sheethal (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,

We have an existing production clustered SQL server with a default
instance
and a named instance. I need to configure Reporting services on the named
instance but am getting the error "Existing cluster or cluster prepared
instance failed".

Has anyone installed RS on a SQL cluster, can you please give me some
steps?

Reply With Quote
  #3  
Old   
Sheethal
 
Posts: n/a

Default Re: Installing Reporting services on a cluster - 11-23-2009 , 10:31 AM



Thanks Geoff.

How would i go about installing it on each node independently.
And what's the downside to installing on a RS cluster? I realize that it
doesnt automatically failover but if i have the RS dbs on the SAN and the
cluster name points to the instance, why doesnt this work?

I am a newbie in RS and trying to understand, hence the questions.

-Thanks
Sheethal

"Geoff N. Hiten" wrote:

Quote:
It is not a good idea to install RS on a cluster. In fact, it is a very bad
idea.

You cannot install a clustered RS instance, you have to install each node
independently.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Sheethal" <Sheethal (AT) discussions (DOT) microsoft.com> wrote in message
news:092B40B0-4447-4FC8-8799-80C71DB3B9B1 (AT) microsoft (DOT) com...
Hi,

We have an existing production clustered SQL server with a default
instance
and a named instance. I need to configure Reporting services on the named
instance but am getting the error "Existing cluster or cluster prepared
instance failed".

Has anyone installed RS on a SQL cluster, can you please give me some
steps?

.

Reply With Quote
  #4  
Old   
Alen Teplitsky
 
Posts: n/a

Default Re: Installing Reporting services on a cluster - 11-25-2009 , 08:10 PM



On Nov 23, 11:31*am, Sheethal <Sheet... (AT) discussions (DOT) microsoft.com>
wrote:
Quote:
Thanks Geoff.

How would i go about installing it on each node independently.
And what's the downside to installing on a RS cluster? I realize that it
doesnt automatically failover but if i have the RS dbs on the SAN and the
cluster name points to the instance, why doesnt this work?

I am a newbie in RS and trying to understand, hence the questions.

-Thanks
Sheethal

"Geoff N. Hiten" wrote:
It is not a good idea to install RS on a cluster. *In fact, it is a very bad
idea.

You cannot install a clustered RS instance, you have to install each node
independently.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Sheethal" <Sheet... (AT) discussions (DOT) microsoft.com> wrote in message
news:092B40B0-4447-4FC8-8799-80C71DB3B9B1 (AT) microsoft (DOT) com...
Hi,

We have an existing production clustered SQL server with a default
instance
and a named instance. I need to configure Reporting services on the named
instance but am getting the error "Existing cluster or cluster prepared
instance failed".

Has anyone installed RS on a SQL cluster, can you please give me some
steps?

.
RS on a cluster is not supported. if you call MS for support they will
probably tell you to uninstall it.

you'll need to install RS on a separate server and keep the RS
databases on the clustered SQL server. caveat is RS will need to run
the enterprise version of SQL. it's called a scale out configuration
and the details are in BOL

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.