all groups > sql server data warehouse > march 2005 >
You're in the

sql server data warehouse

group:

what port does AS listen on ?


what port does AS listen on ? Hassan
3/26/2005 10:17:56 AM
sql server data warehouse:
Does it also listen on 1433 like SQL Server ?

Re: what port does AS listen on ? Hassan
3/27/2005 5:53:23 PM
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

[quoted text, click to view]

Re: what port does AS listen on ? MPS
3/27/2005 6:40:43 PM
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...
[quoted text, click to view]


Re: what port does AS listen on ? Dave Wickert [MSFT]
3/28/2005 9:47:13 AM
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.

[quoted text, click to view]

AddThis Social Bookmark Button