July 25, 2011 at 12:08 pm
According to this Microsoft article http://support.microsoft.com/kb/2466860 "SSAS will start listening on all Public IP addresses of the cluster group using the default port (2383). Any alternate port configuration is ignored."
So if SSAS on a cluster can only listen on one port, what happens if you install a second instance?
Just curious.
Oh, this is Server 2003 and SQL 2005 SP4.
July 25, 2011 at 1:49 pm
See if this is of help
http://msdn.microsoft.com/en-us/library/ms144288(v=sql.90).aspx#SpecifyingAnalysisServicesInstances
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 26, 2011 at 7:18 am
Here's another article that seems to add to the issue -- it clearly says each SSAS instance needs its own port. Whereas the earlier article says SSAS only works on one port in a cluster. Can you have multiple SSAS instances on a cluster?
Each instance of Analysis Services must also have its own port through which clients can connect. This port can either be manually assigned by an Analysis Services administrator or selected dynamically by Analysis Services at startup from the first port available. Regardless of whether the port is manually or dynamically configured, Analysis Services clients are required to have to be able to identify and connect to the port associated with the appropriate instance of Analysis Services.
http://msdn.microsoft.com/en-us/library/ms174906(v=SQL.90).aspx
August 1, 2011 at 4:45 am
Each clustered SSAS instance on a cluster is in its own resource group with its own IP address. Therefore multiple clustered SSAS instances can all listen on their own IP address for port 2383.
It is just the same with clustered SQL DB instances on a cluster. All clustered instances can listen on their own IP address for port 1433.
If you have a Windows cluster where you have installed non-clustered instances of SSAS or SQLDB, then each non-clustered instance must listen on the shared IP address for their own port.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply