RS Setup

We have a two node clustered setup with couple of instances on each node. I
am trying to setup a reporting services on one of the nodes. For testing, we
did IIS install on the same machine. Used configuration tool and setup
reporting database on one of the sql instances. The install didn't report
any errors.
but now the problems is,
1. I created a report using VS business Intelligence tool and tried to
deploy it to report server -- but its failing. I get an error message .. A
connection could not be made to the report server
http://servername/ReportServer. ; Additional Information: The request failed
with HTTP status 503: Service Unavailable (
Microsoft.ReportingServices.Designer). There are virtual directories
'Reportserver' and 'Reports' under the IIS main folder.
2. Even when I try to do http://servername/Reports, I get an error -- The
request failed HTTP status 400: Bad request. I can see the page redirected
before dispalying this message to http://servername/reports/pages/folder.aspx
Any help is appreciated. We have a strong Group policy settings in place at
work on all these servers. All the services are running under the same
domain account except for ASP.NET service.
Thanks
BVR.You may need to use the actual IP address as the servername may not be
resolved with the two-node setup.
To be sure I would "ping" the servername and use the reply IP address in the
TargetServerURL instead of the servername...
See if that works!
-=Steve
"BVR" wrote:
> We have a two node clustered setup with couple of instances on each node. I
> am trying to setup a reporting services on one of the nodes. For testing, we
> did IIS install on the same machine. Used configuration tool and setup
> reporting database on one of the sql instances. The install didn't report
> any errors.
> but now the problems is,
> 1. I created a report using VS business Intelligence tool and tried to
> deploy it to report server -- but its failing. I get an error message .. A
> connection could not be made to the report server
> http://servername/ReportServer. ; Additional Information: The request failed
> with HTTP status 503: Service Unavailable (
> Microsoft.ReportingServices.Designer). There are virtual directories
> 'Reportserver' and 'Reports' under the IIS main folder.
> 2. Even when I try to do http://servername/Reports, I get an error -- The
> request failed HTTP status 400: Bad request. I can see the page redirected
> before dispalying this message to http://servername/reports/pages/folder.aspx
> Any help is appreciated. We have a strong Group policy settings in place at
> work on all these servers. All the services are running under the same
> domain account except for ASP.NET service.
> Thanks
> BVR.
>|||Steve,
I have the same problem. I have checked the scty setting on the Sites in the
IIS section of CompMgt and all seems OK, but when I right click the Site and
selct Browse, I still get Service Unavailable '
--
JK
"Steve Mann" wrote:
> You may need to use the actual IP address as the servername may not be
> resolved with the two-node setup.
> To be sure I would "ping" the servername and use the reply IP address in the
> TargetServerURL instead of the servername...
> See if that works!
> -=Steve
> "BVR" wrote:
> > We have a two node clustered setup with couple of instances on each node. I
> > am trying to setup a reporting services on one of the nodes. For testing, we
> > did IIS install on the same machine. Used configuration tool and setup
> > reporting database on one of the sql instances. The install didn't report
> > any errors.
> >
> > but now the problems is,
> > 1. I created a report using VS business Intelligence tool and tried to
> > deploy it to report server -- but its failing. I get an error message .. A
> > connection could not be made to the report server
> > http://servername/ReportServer. ; Additional Information: The request failed
> > with HTTP status 503: Service Unavailable (
> > Microsoft.ReportingServices.Designer). There are virtual directories
> > 'Reportserver' and 'Reports' under the IIS main folder.
> >
> > 2. Even when I try to do http://servername/Reports, I get an error -- The
> > request failed HTTP status 400: Bad request. I can see the page redirected
> > before dispalying this message to http://servername/reports/pages/folder.aspx
> >
> > Any help is appreciated. We have a strong Group policy settings in place at
> > work on all these servers. All the services are running under the same
> > domain account except for ASP.NET service.
> >
> > Thanks
> > BVR.
> >|||Browsing the Reports or ReportServer should render something. Do you happen
to have SharePoint running on the same IIS? If so, you need to tell
SharePoint that these web sites (or virtual directories) should not be
included.
Otherwise, try running "iisreset" at a command prompt (DOS window -
Start->Run-> cmd).
--
RDA Corp
Business Intelligence Evangelist Leader
www.rdacorp.com
"Joe Kelly" wrote:
> Steve,
> I have the same problem. I have checked the scty setting on the Sites in the
> IIS section of CompMgt and all seems OK, but when I right click the Site and
> selct Browse, I still get Service Unavailable '
> --
> JK
>
> "Steve Mann" wrote:
> > You may need to use the actual IP address as the servername may not be
> > resolved with the two-node setup.
> >
> > To be sure I would "ping" the servername and use the reply IP address in the
> > TargetServerURL instead of the servername...
> >
> > See if that works!
> >
> > -=Steve
> >
> > "BVR" wrote:
> >
> > > We have a two node clustered setup with couple of instances on each node. I
> > > am trying to setup a reporting services on one of the nodes. For testing, we
> > > did IIS install on the same machine. Used configuration tool and setup
> > > reporting database on one of the sql instances. The install didn't report
> > > any errors.
> > >
> > > but now the problems is,
> > > 1. I created a report using VS business Intelligence tool and tried to
> > > deploy it to report server -- but its failing. I get an error message .. A
> > > connection could not be made to the report server
> > > http://servername/ReportServer. ; Additional Information: The request failed
> > > with HTTP status 503: Service Unavailable (
> > > Microsoft.ReportingServices.Designer). There are virtual directories
> > > 'Reportserver' and 'Reports' under the IIS main folder.
> > >
> > > 2. Even when I try to do http://servername/Reports, I get an error -- The
> > > request failed HTTP status 400: Bad request. I can see the page redirected
> > > before dispalying this message to http://servername/reports/pages/folder.aspx
> > >
> > > Any help is appreciated. We have a strong Group policy settings in place at
> > > work on all these servers. All the services are running under the same
> > > domain account except for ASP.NET service.
> > >
> > > Thanks
> > > BVR.
> > >|||Thanks Steve,
I found an article in the Support base that pointed to a conflict between
files from versions of IIS for W2003 and W2003 SP1.
I have uninstalled SSRS and IIS and will reinstall from W2K3SP1 media. Will
report back.
JK
--
JK
"Steve Mann" wrote:
> Browsing the Reports or ReportServer should render something. Do you happen
> to have SharePoint running on the same IIS? If so, you need to tell
> SharePoint that these web sites (or virtual directories) should not be
> included.
> Otherwise, try running "iisreset" at a command prompt (DOS window -
> Start->Run-> cmd).
> --
> RDA Corp
> Business Intelligence Evangelist Leader
> www.rdacorp.com
>
> "Joe Kelly" wrote:
> > Steve,
> >
> > I have the same problem. I have checked the scty setting on the Sites in the
> > IIS section of CompMgt and all seems OK, but when I right click the Site and
> > selct Browse, I still get Service Unavailable '
> >
> > --
> > JK
> >
> >
> > "Steve Mann" wrote:
> >
> > > You may need to use the actual IP address as the servername may not be
> > > resolved with the two-node setup.
> > >
> > > To be sure I would "ping" the servername and use the reply IP address in the
> > > TargetServerURL instead of the servername...
> > >
> > > See if that works!
> > >
> > > -=Steve
> > >
> > > "BVR" wrote:
> > >
> > > > We have a two node clustered setup with couple of instances on each node. I
> > > > am trying to setup a reporting services on one of the nodes. For testing, we
> > > > did IIS install on the same machine. Used configuration tool and setup
> > > > reporting database on one of the sql instances. The install didn't report
> > > > any errors.
> > > >
> > > > but now the problems is,
> > > > 1. I created a report using VS business Intelligence tool and tried to
> > > > deploy it to report server -- but its failing. I get an error message .. A
> > > > connection could not be made to the report server
> > > > http://servername/ReportServer. ; Additional Information: The request failed
> > > > with HTTP status 503: Service Unavailable (
> > > > Microsoft.ReportingServices.Designer). There are virtual directories
> > > > 'Reportserver' and 'Reports' under the IIS main folder.
> > > >
> > > > 2. Even when I try to do http://servername/Reports, I get an error -- The
> > > > request failed HTTP status 400: Bad request. I can see the page redirected
> > > > before dispalying this message to http://servername/reports/pages/folder.aspx
> > > >
> > > > Any help is appreciated. We have a strong Group policy settings in place at
> > > > work on all these servers. All the services are running under the same
> > > > domain account except for ASP.NET service.
> > > >
> > > > Thanks
> > > > BVR.
> > > >

RS on MS Cluster Active/Passive configuration

I have insatalled RS onto an Active Passive SQL Server with IIS installed on
the cluster
as well. I have configured RS on two node work with the same ReportServer
database.
I have moved virtual directory to Shared store...
And now I can run reports on localhost on two nodes,but from Shared store RS
works
only,when Node 1 is active.Then Node 2 is active i get error message :
The encrypted value for configuration setting Dsn cannot be decrypted.
(rsFailedToDecryptConfigInformation) Get Online Help
An internal error occurred on the report server. See the error log for more
details.
(rsInternalError) Get Online Help
My configuration :
MS cluster Active/Passive Windows 2003
SQL 2000 Enterprise + SP3a + Fix 859
RS enterprise + SP1
Any help and guidance in this arena would be appreciated. Thanks.oleg,
It appears that installing RS on an active passive cluster where both
instances of IIS use the same data store it not possible. The reason
is that the DSN information is encrypted per machine and is unique to
the machine. I tried to get luck and synch up the machine keys on the
memebers in the cluster but even after they were synched up, it was
still not possible to get it working. What I have opted to do instead
is to allow each instance of IIS (default web) in the A/P cluster to
respond to the name of the SQLCluster name. When I fail from one box
to the other I am still able to serve up the other version of reporting
services. So while I am not NLB'ing the cluster I am still able to
server two instances of RS. Best idea I have had so far. I am
researching into getting both machines to use the same encryption
algorythm.
Hope that helps.
oleg wrote:
> I have insatalled RS onto an Active Passive SQL Server with IIS
installed on
> the cluster
> as well. I have configured RS on two node work with the same
ReportServer
> database.
> I have moved virtual directory to Shared store...
> And now I can run reports on localhost on two nodes,but from Shared
store RS
> works
> only,when Node 1 is active.Then Node 2 is active i get error message
:
> The encrypted value for configuration setting Dsn cannot be
decrypted.
> (rsFailedToDecryptConfigInformation) Get Online Help
> An internal error occurred on the report server. See the error log
for more
> details.
> (rsInternalError) Get Online Help
> My configuration :
> MS cluster Active/Passive Windows 2003
> SQL 2000 Enterprise + SP3a + Fix 859
> RS enterprise + SP1
> Any help and guidance in this arena would be appreciated. Thanks.