CoryRetherford.com

 

This document will step you through the process to assign and use a fixed port for a named instance of SQL Server Analysis Services (SSAS) and then unblock access to that port and using a fixed port. This is a recommended approach for accessing any Analysis Services instance by Microsoft.

For example servername:port\instancename

To assign a fixed port you will need to unblock the SQL Server Browser service port (UDP 1434) and the defined SSAS instance port. The SQL Server Browser service redirect requests to the fixed instance name port.

• Determine an available TCP/IP port to use
  • Open a command prompt
    • Type netstat –a –p TCP
      • Use a port that is not displayed in the resulting list of TCP ports that are open
• Specify the port by opening SQL Server Management Studio
  • Connect to the SSAS Instance
    • Right click the Instance name and choose Properties
    • A new window opens named Analysis Server Properties
      • Select the General page
        • Scroll down the resulting list to the Name column to Port
        • Change the Value column to the new port number
          • Restart the Analysis Service to apply the setting change
• Configure the Windows Firewall to unblock the TCP port using Group Policy
  • Verify by connecting locally (in Management Studio) and then remotely from a client application on another computer. To use Management Studio, connect to an Analysis Services default instance by specifying a server name in this format: <servername>:<portnumber>. For a named instance, specify the server name as <servername>\<instancename>.

Use Active Directory Group Policy to define the rule sets required to correctly set the SSAS and SQL DB ports up correctly. Use the following which permit all traffic (*) to the defined ports and protocols.

2382:TCP:*:enabled:SSAS
2383:TCP:*:enabled:SSAS Listener
1434:UDP:*:enabled:SQL Browser Listener
1433:TCP:*:enabled:SQL Browser
45xxx:TCP:*:enabled:SSAS Instance

RESOURCE
http://msdn.microsoft.com/en-us/library/ms174937.aspx