question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked DarrenGosbell-0123 commented

SSIS Port and SSAS Port on Azure VM

We have migrated our SSIS and SSAS , on Azure VMs using Rehost approach .

1) What ports should be opened so that Excel User can access Cubes on SSAS Server ?
2) What ports should be opened so that PowerBI User can access Cubes on SSAS Server ?
3) What ports should be opened , so that SSIS Packages can be invoked from PowerShell from another VM ?

All Azure VMs and servers are domain joined

sql-server-integration-servicessql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DarrenGosbell-0123 avatar image
0 Votes"
DarrenGosbell-0123 answered DarrenGosbell-0123 commented

1) What ports should be opened so that Excel User can access Cubes on SSAS Server ?

if it is a default instance port 2383

2) What ports should be opened so that PowerBI User can access Cubes on SSAS Server ?

if it is a default instance port 2383

3) What ports should be opened , so that SSIS Packages can be invoked from PowerShell from another VM ?

Impossible to say without knowing what mechanism you are using from your Powershell script. Is it Powershell remoting, t-sql stored procedure invocation or something else?

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

I want to execute SSIS Pacakge from PowerShell script , as per below article.
https://www.mssqltips.com/sqlservertip/6589/ssis-package-execution-from-powershell/

Then what port should be opened.. Is it 1433 ?

0 Votes 0 ·

I believe that is correct. I think accessing SSIS through the catalog like that will go through the SQL Server port.

0 Votes 0 ·
LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

In addition to the answer, I think you could find the port or firewall configuration descripition in this docu : Configure the Windows Firewall to Allow Analysis Services Access Hope this is useful to you.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.