Bobcares

Change MSSQL port – How to perform and connect

by | Feb 12, 2021

Don’t know how to change the MSSQL port? We can help you.

Since port 1433 is the known standard for SQL Server, the default communication port used by SQL Server for TCP/IP mode connections is TCP 1433.

However, some organizations specify to change the SQL Server port number to enhance security.

As part of our Server Management Services, we assist our customers with several SQL queries.

In this article, let us see how to change the MSSQL port using SQL Server Configuration Manager.

 

Change MSSQL port

To assign a TCP/IP port number to the SQL Server Database Engine our Support Techs suggest the following:

a) In SQL Server Configuration Manager, in the console panel, expand SQL Server Network Configuration, expand Protocols for <instance name> and then double-click TCP/IP.

b) In the TCP/IP Properties dialog box, on the IP Addresses tab, several IP addresses appear in the format IP1, IP2, up to IPAll.

One of these is for the IP address of the loopback adapter, 127.0.0.1. Additional IP addresses appear for each IP Address on the computer.

Right-click each address, and click Properties to identify the IP address that we want to configure.

c) If the TCP Dynamic Ports dialog box contains 0, indicating the Database Engine is listening on dynamic ports, delete the 0.

d) In the IPn Properties area box, in the TCP Port box, we type the port number we want this IP address to listen on, and then click OK.

If the Listen All setting on the Protocol tab is set to “Yes”, then it will only use TCP Port and TCP Dynamic Port values under the IPAll section and ignore individual IPn sections entirety.

If the Listen All setting is set to “No”, then it will ignore the TCP Port and TCP Dynamic Port settings under the IPAll section and use the TCP Port, TCP Dynamic Port, and Enabled settings on the individual IPn sections.

Each IPn section has an Enabled setting with a default value of “No” which causes SQL Server to ignore this IP address even if it has a port defined.

e) In the console panel, click SQL Server Services.

f) In the details panel, right-click SQL Server (<instance name>) and then click Restart, to stop and restart SQL Server.

Make sure the port is open in the Windows firewall.

In order to open a port, follow the steps given below:
  1. From the Start menu >> Control Panel >> System and Security >> Windows Firewall.
  2. Then click Advanced Settings >> Inbound Rules >> New Rule in the Actions window >> Rule Type of Port >> Next.
  3. On the Protocol and Ports page click TCP.
  4. Select Specific Local Ports and type the port number.
  5. Click Next.
  6. On the Action page, click Allow the connection.
  7. Click Next.
  8. On the Profile page, click the appropriate options for our environment.
  9. Click Next.
  10. On the Name page, enter a name.
  11. Click Finish.
  12. Restart the computer.

 

How to connect to a specific port

Once we configure SQL Server to listen on a specific port, there are three ways to connect to a specific port with a client application:

  • Run the SQL Server Browser service on the server to connect to the Database Engine instance by name.
  • Create an alias on the client, specifying the port number.
  • Program the client to connect using a custom connection string.

[Couldn’t change MSSQL port? We’d be happy to assist you.]

 

Conclusion

In short, in this article, our Support Techs guides you on how to change the MSSQL port using SQL Server Configuration Manager.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = "owonCMyG5nEQ0aD71QM";

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Never again lose customers to poor
server speed! Let us help you.

Privacy Preference Center

Necessary

Necessary cookies help make a website usable by enabling basic functions like page navigation and access to secure areas of the website. The website cannot function properly without these cookies.

PHPSESSID - Preserves user session state across page requests.

gdpr[consent_types] - Used to store user consents.

gdpr[allowed_cookies] - Used to store user allowed cookies.

PHPSESSID, gdpr[consent_types], gdpr[allowed_cookies]
PHPSESSID
WHMCSpKDlPzh2chML

Statistics

Statistic cookies help website owners to understand how visitors interact with websites by collecting and reporting information anonymously.

_ga - Preserves user session state across page requests.

_gat - Used by Google Analytics to throttle request rate

_gid - Registers a unique ID that is used to generate statistical data on how you use the website.

smartlookCookie - Used to collect user device and location information of the site visitors to improve the websites User Experience.

_ga, _gat, _gid
_ga, _gat, _gid
smartlookCookie
_clck, _clsk, CLID, ANONCHK, MR, MUID, SM

Marketing

Marketing cookies are used to track visitors across websites. The intention is to display ads that are relevant and engaging for the individual user and thereby more valuable for publishers and third party advertisers.

IDE - Used by Google DoubleClick to register and report the website user's actions after viewing or clicking one of the advertiser's ads with the purpose of measuring the efficacy of an ad and to present targeted ads to the user.

test_cookie - Used to check if the user's browser supports cookies.

1P_JAR - Google cookie. These cookies are used to collect website statistics and track conversion rates.

NID - Registers a unique ID that identifies a returning user's device. The ID is used for serving ads that are most relevant to the user.

DV - Google ad personalisation

_reb2bgeo - The visitor's geographical location

_reb2bloaded - Whether or not the script loaded for the visitor

_reb2bref - The referring URL for the visit

_reb2bsessionID - The visitor's RB2B session ID

_reb2buid - The visitor's RB2B user ID

IDE, test_cookie, 1P_JAR, NID, DV, NID
IDE, test_cookie
1P_JAR, NID, DV
NID
hblid
_reb2bgeo, _reb2bloaded, _reb2bref, _reb2bsessionID, _reb2buid

Security

These are essential site cookies, used by the google reCAPTCHA. These cookies use an unique identifier to verify if a visitor is human or a bot.

SID, APISID, HSID, NID, PREF
SID, APISID, HSID, NID, PREF