Forum Discussion

thomascyc's avatar
thomascyc
Copper Contributor
Feb 09, 2023

SSIS Deploy non 1433 port SQL Server

The 64bit SQL server change the port to 61433 And, I try to deploy ISPAC file from SSMS or command line (ISDeploymentWizard.exe) but fail.   The error : Failed to deploy project. For more infomat...
bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Feb 09, 2023

Hi thomascyc --  Have you verified there isn't a firewall blocking that port?  If not, I would recommend testing connectivity using "test-netconnection -ComputerName <SQL Server Name Here> -Port 61433".  Take care.

  • thomascyc's avatar
    thomascyc
    Copper Contributor
    Mar 07, 2023

    bake13Thanks your reply, The SSIS and MSSQL server are same server. Windows Firewall is disabled. And, tested by telnet of port 61433 is open.

     

     

Resources