Ports and protocols used by Microsoft SQL Server database engine (SQLServer).
About this task
Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) which is used by Microsoft. You need to allow distant users to connect to the SQL server so they can address it their queries.
- Enable remote connections to your SQL Server.
Microsoft SQL Server by default uses TCP 1433 but this can be changed using SQL Server Enterprise Manager or the database Management Studio.
- Enable TCP/IP.
- Open the 1433 port in your firewall.
- If you are using a named instance, create an extra rule in your firewall with the port 1434.Note: For a named SQL Server instance (e.g. [yourServerInstance]\SQL2012SP2), the firewall needs an extra rule on the UDP protocol with the specific port 1434. Without this rule the system will return the exception
error: 26 - Error Locating Server/Instance Specified.
- Display the firewall advanced settings by navigating to Control Panel > System and Security > Windows Firewall > Advanced settings.
- Select Inbound Rules in the left-hand pane, then click New Rule in the right-hand pane.
- In the New Inbound Rule Wizard, Rule Type step, select Port.
- Protocols and Ports step, select UDP and set Specific local ports to
- Action step, select Allow the connection.
- Profile step, tick the Domain checkbox.
- Name step, enter a name for this rule, e.g.
Named instance port 1434.
- Select Finish.