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.
- Open SQL server configuration Manager >> SQL Server Services
- Now right click on SQL Server and choose “Restart” option.
- 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.