Friday, March 9, 2012

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.
> > > >

No comments:

Post a Comment