Server Architecture (Analysis Services)

Microsoft SQL Server 2005 Analysis Services (SSAS) uses both server and client components to supply online analytical processing (OLAP) and data mining functionality for business intelligence applications:

i) Server component

  The server component of SSAS is the msmdsrv.exe application which consists of security components, an XML for Analysis(XMLA) listener component, a query processor component and numerous other internal components that perform the following functions:

Parsing statements received from clients

Managing metadata

Handling transactions

Processing calculations

Storing dimension and cell data

Creating aggregations

Scheduling queries

Caching objects

Managing server resources

 XMLA Listener
The XMLA listener component handles all XMLA communications between Analysis Services and its clients.
Analysis Services uses the following default TCP ports:

Port	Description
2725	Existing instances of SQL Server 2000 Analysis Services.
2383	Default instance of SQL Server 2005 Analysis Services.
2382	Redirector for other instances of SQL Server 2005 Analysis Services.
Dynamically assigned at server startup	Named instance of SQL Server 2005 Analysis Services.

ii)Client component