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 |