dbTalk Databases Forums  

SQL Reporting Missing

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


Discuss SQL Reporting Missing in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Girish J Bhatia
 
Posts: n/a

Default SQL Reporting Missing - 04-27-2009 , 03:56 AM






Dear Experts,

I have a two node cluster SQL_N1 & SQL_N2, I installed setup from Node 2
where IIS was installed and in Node 1 there was no IIS Installed so it looks
like that it has installed Reporting services only on Node 2.

My Main objective here is to get the SQL Reporting working on Node 1. I
checked in Node2 and I can see that Reporting services is installed but not
working. In Node 1, I cannot see it installed anywhere. When I go to
add/remove programs and click on change on SQL 2005 Server - I cannot see the
Reporting Services. The funniest part is that when I re-ran setup on Node 1
it says Analysis, Database are installed & does not show that Reporting
services - which is missing. So I proceeded further to install the component
but then SQL identifies that all the services are installed.

How do I install or re-install SQL Reporting Services? Will this affect my
Cluster? I really dont want to re-install here.

What I have tried? I copied the Reports Database, Folders & IIS Virtual
Directory from Node 2 to Node 1 but invain. Can someone help me!

Thank you all in advance...

Best Regards,
--
Girish J Bhatia
MOSS Certified, SharePoint Certified, MCSE2003, MCDBA, CCNA, CCNP, CCSA

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.