SQL Server 2014 Tutorial – Assign TCP/IP Port to Database Engine

Published on March 27, 2016 by abundantcode

Filed under SQL Server

Last modified March 27, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 4 (1 votes)

This article have been viewed 3241 times

Problem Statement

You need to change the SQL Server 2014 port number from 1433 to a different port number.

Solution

By default , SQL Server runs on the port number 1433. You can change it to different port number by following the below steps.

1. Open SQL Server 2014 Configuration Manager from the Windows Start menu.
image

2. In the left side bar of the Sql Server Configuration Manager , expand the "SQL Server Network Configuration" and click the protocols for SQLExpress. Right click on the TCP/IP in the content area and click enable. Right click on the TCP/IP and select properties.

image
3. In the TCP/IP Properties , click the IP Addresses tab and scroll till the end to identify the IPALL section. You can change the port number to your desired port here. Lets Give the Port number as 1434.

image

Note that if you change the port number to anything apart from 1433 , you need to specify or include it when connecting to this server.

4. Restart the instance of the SQL Server by following the below steps
– Click "SQL Server Services" in the left sidebar.
– Select SQL Server (SQLExpress), right click and click on "Restart" from the context menu.

image

5. Now , when you connect to SQLExpress from Management studio , you need to provide the port number as well.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

1 Comment

  1. SQL Server 2014 Tutorial – Open SQL Server Instance Port in Windows Firewall | Abundant Code
    March 27, 2016 - 7:09 pm

Leave a Comment


x

You might be Interested in these Posts

C Program to display Inverted half-pyramid using *

Problem Write a program in C to print Inverted half-pyramid using * as shown below.The program shou...

How to use array Rank in C# ?

In C# , the Rank property of the array is is used to get the rank of the array. In simple terms , ra...

How to append an array to another in JavaScript ?

In JavaScript , you may want to append one array to another array(s) to combine their elements resul...