all groups > sql server clustering > april 2007 >
You're in the

sql server clustering

group:

Analysis Service Ports



Analysis Service Ports FredG
4/24/2007 1:50:04 PM
sql server clustering: SQL 2005 AS installed on a Cluster.

We are using a named instance and only one currently exists. MS White paper
reads: The default instance listens on port 2383, while named instances are
dynamically allocated. This behavior can be changed by explicitly assigning a
port to either the default or named instance of SSAS. If the value for Port
is 0, the default behavior described above is achieved. Otherwise, the value
is treated as an absolute (static) port number to use for the specified
instance.

I have modifed the Server PORT property, on the named instance (a default
instance does not exist) to listen on port 2382 and have added a rule to our
firewall to allow this traffic. However, AS continues to listen on port 2383.
Does anyone have any experience on this and how to change it.

Re: Analysis Service Ports FredG
5/8/2007 2:09:01 PM
I have restarted the service multiple times and it continues to listen on
this port.

[quoted text, click to view]
Re: Analysis Service Ports Zakiuddin Mohammed
5/8/2007 4:01:45 PM
I am not sure on SQL 2005 but in SQL 2000 you need to start the service
again to take the effect of new port numbers...
Zaki.

[quoted text, click to view]

AddThis Social Bookmark Button