asked
what are the ports we are using in sql server except 1433?
what are the ports we are using in sql server except 1433?
Default ports are in table below: Service Port Port type Note SQL Server Engine 1433 TCP SQL Server Browser 1434 UDP SSAS 2383 TCP SSIS 135 TCP Cannot be changed SSRS 80 TCP However those are default ports. If you run named instances, than by default htose instances are running on dynamic ports, which can be changed to fixed one in the SQL Server Configuration manager.
In addition to @Pavel's response, you may also need Port 2382 for the SSAS browser. You can see which address & port an instance of SQL Server is running with the following bit of code: select distinct local_net_address, local_tcp_port from sys.dm_exec_connections where net_transport = 'TCP'
14 People are following this question.
