Unix Technical Forum

what port does AS listen on ?

This is a discussion on what port does AS listen on ? within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> Does it also listen on 1433 like SQL Server ?...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server Data Warehousing

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 06:23 PM
Hassan
 
Posts: n/a
Default what port does AS listen on ?

Does it also listen on 1433 like SQL Server ?


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 06:23 PM
MPS
 
Posts: n/a
Default Re: what port does AS listen on ?

Run Fport.exe and found:

Pid Process Port Proto Path
384 msmdsrv -> 2393 TCP C:\Archivos de programa\Microsoft
Analysis Services\Bin\msmdsrv.exe
384 msmdsrv -> 2394 TCP C:\Archivos de programa\Microsoft
Analysis Services\Bin\msmdsrv.exe
384 msmdsrv -> 2725 TCP C:\Archivos de programa\Microsoft
Analysis Services\Bin\msmdsrv.exe
384 msmdsrv -> 123 UDP C:\Archivos de programa\Microsoft
Analysis Services\Bin\msmdsrv.exe
384 msmdsrv -> 4500 UDP C:\Archivos de programa\Microsoft
Analysis Services\Bin\msmdsrv.exe
384 msmdsrv -> 36818 UDP C:\Archivos de programa\Microsoft
Analysis Services\Bin\msmdsrv.exe

Cheers

Michael Prendergast

"Hassan" <fatima_ja@hotmail.com> escribió en el mensaje
news:usuyjAjMFHA.580@TK2MSFTNGP15.phx.gbl...
> Does it also listen on 1433 like SQL Server ?
>
>
>




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 06:23 PM
Hassan
 
Posts: n/a
Default Re: what port does AS listen on ?

Id like to do some port mapping and if I cant figure it out, then how do I
map ? I was hoping there would be one like 1433 for SQL Server

"MPS" <mps@udd.cl> wrote in message
news:uOwm%233xMFHA.3708@TK2MSFTNGP14.phx.gbl...
> Run Fport.exe and found:
>
> Pid Process Port Proto Path
> 384 msmdsrv -> 2393 TCP C:\Archivos de programa\Microsoft
> Analysis Services\Bin\msmdsrv.exe
> 384 msmdsrv -> 2394 TCP C:\Archivos de programa\Microsoft
> Analysis Services\Bin\msmdsrv.exe
> 384 msmdsrv -> 2725 TCP C:\Archivos de programa\Microsoft
> Analysis Services\Bin\msmdsrv.exe
> 384 msmdsrv -> 123 UDP C:\Archivos de programa\Microsoft
> Analysis Services\Bin\msmdsrv.exe
> 384 msmdsrv -> 4500 UDP C:\Archivos de programa\Microsoft
> Analysis Services\Bin\msmdsrv.exe
> 384 msmdsrv -> 36818 UDP C:\Archivos de programa\Microsoft
> Analysis Services\Bin\msmdsrv.exe
>
> Cheers
>
> Michael Prendergast
>
> "Hassan" <fatima_ja@hotmail.com> escribió en el mensaje
> news:usuyjAjMFHA.580@TK2MSFTNGP15.phx.gbl...
> > Does it also listen on 1433 like SQL Server ?
> >
> >
> >

>
>
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-27-2008, 06:23 PM
Dave Wickert [MSFT]
 
Posts: n/a
Default Re: what port does AS listen on ?

Sorry. The port numbers in AS2K cannot be changed.

There is new functionality coming with AS2K5 around multi-instancing and
active-active cluster support that allows you to change the port numbers
that AS uses.

BTW:
2725 = SQL 7 OLAP Services port #
2393 and 2394 = SQL 2000 Analysis Services port #s
The other ports are for authentication.

36818 must be for an outbound connection (and connection polling is leaving
it open) after processing or something like that. I've never seen that nor
the 4500 port below.
--
Dave Wickert [MSFT]
dwickert@online.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.

"Hassan" <fatima_ja@hotmail.com> wrote in message
news:ufFrtjzMFHA.2604@TK2MSFTNGP10.phx.gbl...
> Id like to do some port mapping and if I cant figure it out, then how do I
> map ? I was hoping there would be one like 1433 for SQL Server
>
> "MPS" <mps@udd.cl> wrote in message
> news:uOwm%233xMFHA.3708@TK2MSFTNGP14.phx.gbl...
> > Run Fport.exe and found:
> >
> > Pid Process Port Proto Path
> > 384 msmdsrv -> 2393 TCP C:\Archivos de programa\Microsoft
> > Analysis Services\Bin\msmdsrv.exe
> > 384 msmdsrv -> 2394 TCP C:\Archivos de programa\Microsoft
> > Analysis Services\Bin\msmdsrv.exe
> > 384 msmdsrv -> 2725 TCP C:\Archivos de programa\Microsoft
> > Analysis Services\Bin\msmdsrv.exe
> > 384 msmdsrv -> 123 UDP C:\Archivos de programa\Microsoft
> > Analysis Services\Bin\msmdsrv.exe
> > 384 msmdsrv -> 4500 UDP C:\Archivos de programa\Microsoft
> > Analysis Services\Bin\msmdsrv.exe
> > 384 msmdsrv -> 36818 UDP C:\Archivos de programa\Microsoft
> > Analysis Services\Bin\msmdsrv.exe
> >
> > Cheers
> >
> > Michael Prendergast
> >
> > "Hassan" <fatima_ja@hotmail.com> escribió en el mensaje
> > news:usuyjAjMFHA.580@TK2MSFTNGP15.phx.gbl...
> > > Does it also listen on 1433 like SQL Server ?
> > >
> > >
> > >

> >
> >
> >

>
>



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:35 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com