Steps to change MSSQL server 2008 port

kumkumsharma

Administrator
Staff member
AS we know Windows VPS default port number is 1533but if we want to change the default port then we have to follow below steps:
  • Login to your Windows VPS.
  • Navigate to Start >> All Programs >> Microsoft SQL Server 2008 R2 >> Configuration Tools >> SQL Server Configuration Manager.
  • Now choose “SQL Server Network Configuration” under “Configuration Tools”.
  • And select “Protocols for SQLEXPRESS”.
  • Now right click on “TCP/IP Protocol” and choose “Properties”.
  • Click on “IP Addresses” Tab.
  • Under “IP ALL” section you will find “TCP port” number option, you can change port number.
  • And click on “Apply” and then “OK” button.
  • After that restart SQL Server Services.
To Restart SQL Server you can follow:
  • Open SQL server configuration Manager >> SQL Server Services
  • Now right click on SQL Server and choose “Restart” option.
You can check that your updated port number is working or not.
  • Open SQL Server Management Studio and navigate to Start >> All Programs >> Microsoft SQL Server 2008 R2 >> Configuration Tools >> SQL Server Configuration Manager.
  • Now you will find login window where you have to enter server IP address along with port number (i.e. 127.0.0.0,1991) as Server Name.
 
Top