Change the TCP port of SQL Server

The default SQL Server port of 1433 is blocked at our border routers for security purposes. Therefore, the port that SQL Server runs on will need to be changed if you would like to connect to it remotely. Be advised, however, that if you do so, you leave yourself open to other remote connections as well. Do so at your own risk.

1. You can do this by opening the Server Network Utility. (Start -> Programs -> Microsoft SQL Server -> Server Network Utility).

2. On the General tab, make sure TCP/IP is highlighted, and click Properties.

3. Type in the port number you wish to use.

4. Restart the SQL Server service.

Need More Personalized Help?

If you have any further issues, questions, or would like some assistance checking on this or anything else, please reach out to us from your my.hivelocity.net account and provide your server credentials within the encrypted field for the best possible security and support.

If you are unable to reach your my.hivelocity.net account or if you are on the go, please reach out from your valid my.hivelocity.net account email to us here at: [email protected]. We are also available to you through our phone and live chat system 24/7/365.

Back to: Database

Create a Free Account

Chat with an Expert

Configure a Bare Metal Server

Latest

Categories +

Database

...

Tags +

...