locked
What Port should I open for SSAS 2382 or 2383? RRS feed

  • Question

  • Hi,

    I am working in the environment where all ports are closed. In result Data Analysis views are not working from all client terminals (as they are on diff vlans). Now, please tell me what port should I open 2382 or 2383 for SSAS?

    Many Thanks

    Best Regards,
    Mohsin Raza

    Tuesday, December 7, 2010 4:53 AM

Answers

  • you can look in the SQL Server Configuration to determine if there is a named or default instance installed.  Another way to
    determine between a default and named instance is using Powershell
    http://www.mssqltips.com/tip.asp?tip=2013

    Other very basic way to identify is by using SQL configuration tools >> configuration manager  >> Click on SQL 2005 Services
    it will list all the instances, look for the names in brackets, the default name of instance is [MSSQLSERVER], else a named instance would have different name specified during install 

    Hope this helps

     


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Tuesday, December 7, 2010 8:37 AM

All replies

  • Please help me. Badly required.

    Tuesday, December 7, 2010 6:18 AM
  •  

    The default instance of SQL Server Analysis Services will normally be listening on port 2383. If you are using named instances in SQL Server Analysis Services, then the SQL Server Browser service needs to be running on the server to give clients who are accessing it a port for the named instance. The SQL Server Browser is normally on port 2382.

    Named instances of Analysis Services will have other dynamically allocated ports. These can be discovered by looking in the configuration file for the SQL Server Browser. For checking the port no, navigate as mentioned below

    1. On the computer on which SQL Server 2005 Analysis Services is running, open the msmdredir.ini file in a text editor. The default location is C:\Progarm files\Microsoft SQL Server\90\Shared\ASConfig.

    2. In the <Instances> section of the msmdredir.ini file, note the text

    Also if you have extranet users get port 2725 opened for OWC communication

    For further details refer to http://technet.microsoft.com/en-us/library/cc197552(office.12).aspx


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    • Proposed as answer by Badal Ratra Tuesday, December 7, 2010 6:57 AM
    Tuesday, December 7, 2010 6:33 AM
  • Dear Sunil,

    We have default instance of SSAS, but how to confirm this and how to check that named instance is using or not? btw we are just using it for data analysis views.

    Tuesday, December 7, 2010 8:13 AM
  • you can look in the SQL Server Configuration to determine if there is a named or default instance installed.  Another way to
    determine between a default and named instance is using Powershell
    http://www.mssqltips.com/tip.asp?tip=2013

    Other very basic way to identify is by using SQL configuration tools >> configuration manager  >> Click on SQL 2005 Services
    it will list all the instances, look for the names in brackets, the default name of instance is [MSSQLSERVER], else a named instance would have different name specified during install 

    Hope this helps

     


    Thanks | Sunil Kr Singh | http://epmxperts.wordpress.com
    Tuesday, December 7, 2010 8:37 AM
  • Thanks Sunil. Now its all clear.
    Tuesday, December 7, 2010 9:21 AM