Change SQL Server Analysis Services Port

Leave a comment (0) Go to comments

Can I Change SQL Server Analysis Services Port ?

How to Change SQL Server Analysis Services Port ?

Yes, you can change SQL Server Analysis Services Port my making Changes in Analysis Services Configuration File.

There are two ways of Changing SQL Server Analysis Services

  1. Change SSAS port using Configuration File
  2. Change SSAS port using Server Properties

Steps to Change SQL Services Analysis Services Port using Configuration File

Step 1 Check SQL Server Analysis current Configuration File

You can check the Port setting in SQL Server Analysis Services Configuration file named "msmdsrv.ini", this file is located in directory C:\Program Files\Microsoft SQL Server \MSQL\OLAP\Config\

Inside msmdsrv.ini file, you can find an entry like, <Port>0</Port>, which means, Analysis Services us running on dynamic port, which means every time your restart the Analysis Services, a new port will be associated to Analysis Services.

If there there is any number other than 0 (Zero) means SQL Server Analysis Services are running on dedicated port only.

Change SQL Server Analysis Services Port SSAS change port Change Analysis Services Port Graphically analysis service port


Step 2 Change Port Information in SQL Server Analysis Configuration File

Update <Port>0</Port>  with <Port>new Port number</Port>.

In My case, I wanted my Analysis services to be run on port 2383, then I will change 

<Port>0</Port>  with <Port>2385</Port>

and follow STEP 3 and Step 4 to make this changed effective

Steps to Change SQL Services Analysis Services Port using Configuration File

We can also make this changes by connecting to SQL Server Analysis Services, Right Click on Analysis Services Instance and Select properties.

In properties window, change the Port number as shown below in screen shot.

Change SQL Server Analysis Services Port SSAS change port Change Analysis Services Port Graphically analysis service port

Step 3 Restart Analysis Services

Restart of SQL Server Analysis Services is required, in case you are changing a port information.

Step 4 Test SQL Server Analysis Services New Port

You can test a new port by making a connection to Analysis Services by specifying port number in connection string.

In my case, I am running Analysis Services locally, so I am trying to make a connection to local IP address and analysis port 2385

Change SQL Server Analysis Services Port SSAS change port Change Analysis Services Port Graphically analysis service port

Once you Click on Connect, you should be able to connect like in my case.

Change SQL Server Analysis Services Port SSAS change port Change Analysis Services Port Graphically analysis service port

This Confirms that, you have successfully changes SQL Server Analysis port. Now SQL Server Analysis Services will always be running on port number, which you have specified.

EOF - Change SQL Server Analysis Services Port, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.