dbTalk Databases Forums  

Analysis Services and firewall

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Analysis Services and firewall in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roberto Lo Baido
 
Posts: n/a

Default Analysis Services and firewall - 01-14-2005 , 06:01 AM






I've a server with sql 2000 sp3, analysis services sp3 and iis6. On that
server i've created an asp website linked to the cubes with pivot table 10

From a client NT4 i try to browse the site but the pivot table return
"unable to connect to server"

Maybe the problem is the firewall. Which ports do i have to open in the
firewall settings to enable OLE-DB bProvider to OLAP Services 8.0?
Thanks

Reply With Quote
  #2  
Old   
Dave Wickert [MSFT]
 
Posts: n/a

Default Re: Analysis Services and firewall - 01-14-2005 , 12:06 PM






This can be many issues. I would recommend that you review the material in:
http://msdn.microsoft.com/library/de...l_datapump.asp
and
http://www.microsoft.com/technet/pro.../anservog.mspx
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Roberto Lo Baido" <RobertoLoBaido (AT) discussions (DOT) microsoft.com> wrote in
message news:44562A32-77F7-4301-A462-F82AEBE83E7F (AT) microsoft (DOT) com...
Quote:
I've a server with sql 2000 sp3, analysis services sp3 and iis6. On that
server i've created an asp website linked to the cubes with pivot table 10

From a client NT4 i try to browse the site but the pivot table return
"unable to connect to server"

Maybe the problem is the firewall. Which ports do i have to open in the
firewall settings to enable OLE-DB bProvider to OLAP Services 8.0?
Thanks



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.