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 5687 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.

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

Video - Angular Router - Brian Ford

Video - Angular Router - Brian Ford http://www.youtube.com/watch?v=sfV0ApyN5fM ...

Video - An Angular2 Todo App: First look at App Development in Angular2

In this screencast , David East , one of the core contributor of the Angular provides a glimpse of A...

Video - Getting started with Angular 2

In this screencast , Alex Eagle , developer on the Angular team talks about Angular 2 developer prev...