Can we change TCP port for Analysis server 2005 named instances

  • Hi, just wanted to know if we can change TCP port for Analysis server 2005 named instances

    What I know is for named instances, Port will be dynamically assigned to client by browser service and hence we cannot change it. Pls correct me if my understanding is wrong

    Thanks in Advance

    SNT

  • Yes, these can be changed. Read up on managing instances here and then navigate in win explorer to %Program files%\Microsoft SQL Server\90\Shared\ASConfig and review the contents of the msmdredir.ini file.

    In that file you should find entries like below, change the port to what you require.

    <Instances>

    <Instance>

    <Name>MyInstance</Name>

    <Port>9999</Port>

    </Instance>

    </Instances>

    Steve.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply