Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: How to Change the MSSQL Port Number  (Read 2488 times)

0 Members and 1 Guest are viewing this topic.

rohitj

  • Guest
How to Change the MSSQL Port Number
« on: November 16, 2013, 10:13:13 pm »
Change the MSSQL Port Number

In order to change MSSQL port,  follow the steps below.

Login to server via RDP
Click on Start
Click on All Programs
Select SQL Server Management Studio
Click on Configuration Tools   =>  SQL Server  Configuration Manager => Expand SQL Server  2008 Network Configuration => Click on Protocols for MSSQLSERVER => Right Click TCP/IP and click properties

Drop down to the bottom of the window and change the paramenter "TCP Port" to the desired port you want.

Please don't forget to add this port in firewall.