How can I change default port for all SQL traffic.

book

Article ID: 179920

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Question
Customer wants to change the default port for all SQL traffic. He is planning to move his Notification Server to a DMZ and as part of his security regulations he wants to be able to change the default communication ports and one of these ports is the SQL server port.

Answer
Note:: The following steps are provided for informational purposes only. If you experience difficulty in implementing these steps, please contact Microsoft support for assistance.

The following steps are simple and generic. The intent of this article is to give you an idea of what you need to do.

1) Create an Alias using the Client Network Utility. Another approach is to create the reg key for this Alias:
You need to go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo and create a new string key. E.g. this key could be named MyPort. The reg key needs to have the following information:
DBMSSOCN, MyPort, the port number that you want.

DBMSSOCN, MyPort, 4455

2) Configure the default port that TCP/IP uses on the SQL Server Client Network Utility.  If you open this utility and highlight TCP/IP under "Enabled Protocols by Order" and then select Properties you need to change the default port from 1433 to the new port number. This must be done along with the Alias that we had configured already. Once these two items were in place the NS could talk to the database host server over TCP/IP.