Menu
I have a VB6 application that uses SQL server. It needs to access it through a LAN. Therefore I want to make an exception in firewall.
What is the default port of microsoft SQL server ?
(I am using Microsoft SQL Server 2005)
779
The default instance of SQL Server listens on Port 1433. Port 1434 is used by the SQL Browser Service which allows connections to named instances of SQL Server that use dynamic ports with out having to know what port each named instance is using, especially since this can change between restarts of the named instance.
TCP 1433. TCP port 1433 is the default port for SQL Server. This SQL port is also the official Internet Assigned Number Authority (IANA) socket number for SQL Server.
The alternative port is 14330. If you find that your ISP or firewall is blocking the standard SQL port (1433), you can configure your SQL client to connect via the alternative port.
The default port of SQL server is 1433.
152
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
