hi all;
What is the reporting services port number, like we have to ensure that port
1433 is open in the firewall, and the same for OLAP there is a port no
related to it, can any one tell me what is the port no we have to open it in
the firewall for the reporting services?
thanks in advancedIt is just a web application using HTTP protocol, and served by IIS. So the
default port would be 80. Of course the website/app could be configured to
use different port. Th be sure, go to the IIS manager to see the
website/app's configuration.
"yaser" <yaser.abu-khudier@.hotmail.com> wrote in message
news:OpN78n6cIHA.288@.TK2MSFTNGP02.phx.gbl...
> hi all;
> What is the reporting services port number, like we have to ensure that
> port 1433 is open in the firewall, and the same for OLAP there is a port
> no related to it, can any one tell me what is the port no we have to open
> it in the firewall for the reporting services?
>
> thanks in advanced
>|||Olap runs off 2725 for Sql 2000 and 2383 for Sql 2005
SRS by default uses the Default website which runs off Port 80.
SRS can however work off pretty much any port and or website. The downside
to this being the port number would be exposed in the URL. (if it is anything
but 80.)
This would need to be addressed.
Rob
--
"yaser" wrote:
> hi all;
> What is the reporting services port number, like we have to ensure that port
> 1433 is open in the firewall, and the same for OLAP there is a port no
> related to it, can any one tell me what is the port no we have to open it in
> the firewall for the reporting services?
>
> thanks in advanced
>
>
Showing posts with label olap. Show all posts
Showing posts with label olap. Show all posts
Friday, March 23, 2012
Wednesday, March 21, 2012
Reporting Services OLAP Report through Report Manager
I am creating a report in Reporting Services that hits an Analysis services
cube using MDX. The report has parameters so some of the MDX queries are
placed into strings. When running the report on my local machine it works
correctly, but when I deploy the report and run it through Report Manager it
locks up and will not display. It also brings down the Web server for a few
minutes.
The parameter lists in the report are created with a static MDX statement
and they will display, but the report keeps turning and never renders to the
screen.
I have looked at the site
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
but I cannot find anything on why the report would work locally but not
through Report manager.
Any advice or directions would be greatly appreciated.I was able to solve this problem. The SQK server with my Cubes had Analysis
Services SP3. The box that I was developing the OLAP report was also running
AS SP3 but the Report Server did not have any service packs installed. This
was causing the OLAP report to lock up on the report server. Analysis
services was installed onto the report server after the report server and
visual studio. I believe that Analysis services over wrote the MSOLAP80.dll
to the 8.0.195 version.
After installing AS SP3 on the report server I was able to view OLAP Reports
through the Report Manager without locking up or bring down the web server.
"AndyT" wrote:
> I am creating a report in Reporting Services that hits an Analysis services
> cube using MDX. The report has parameters so some of the MDX queries are
> placed into strings. When running the report on my local machine it works
> correctly, but when I deploy the report and run it through Report Manager it
> locks up and will not display. It also brings down the Web server for a few
> minutes.
> The parameter lists in the report are created with a static MDX statement
> and they will display, but the report keeps turning and never renders to the
> screen.
> I have looked at the site
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
> but I cannot find anything on why the report would work locally but not
> through Report manager.
> Any advice or directions would be greatly appreciated.
>
cube using MDX. The report has parameters so some of the MDX queries are
placed into strings. When running the report on my local machine it works
correctly, but when I deploy the report and run it through Report Manager it
locks up and will not display. It also brings down the Web server for a few
minutes.
The parameter lists in the report are created with a static MDX statement
and they will display, but the report keeps turning and never renders to the
screen.
I have looked at the site
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
but I cannot find anything on why the report would work locally but not
through Report manager.
Any advice or directions would be greatly appreciated.I was able to solve this problem. The SQK server with my Cubes had Analysis
Services SP3. The box that I was developing the OLAP report was also running
AS SP3 but the Report Server did not have any service packs installed. This
was causing the OLAP report to lock up on the report server. Analysis
services was installed onto the report server after the report server and
visual studio. I believe that Analysis services over wrote the MSOLAP80.dll
to the 8.0.195 version.
After installing AS SP3 on the report server I was able to view OLAP Reports
through the Report Manager without locking up or bring down the web server.
"AndyT" wrote:
> I am creating a report in Reporting Services that hits an Analysis services
> cube using MDX. The report has parameters so some of the MDX queries are
> placed into strings. When running the report on my local machine it works
> correctly, but when I deploy the report and run it through Report Manager it
> locks up and will not display. It also brings down the Web server for a few
> minutes.
> The parameter lists in the report are created with a static MDX statement
> and they will display, but the report keeps turning and never renders to the
> screen.
> I have looked at the site
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
> but I cannot find anything on why the report would work locally but not
> through Report manager.
> Any advice or directions would be greatly appreciated.
>
Subscribe to:
Posts (Atom)