In Windows VPS, 1533 is the default port for MSSQL Server. Following steps will guide you to change the default port for the MSSQL Server:
- Login to your VPS.
- Go to Start → All Programs → Microsoft SQL Server 2008 R2 → Configuration Tools → SQL Server Configuration Manager.
- Select SQL Server Network Configuration.
- Select Protocols for SQLEXPRESS.
- Select Properties of TCP/IP Protocol.
- Move to IP Addresses Tab.
- Scroll Down and modify the Port number from IP ALL Section.
- Click on Apply and OK button.
- Now restart SQL Server Services.
- For this, click on SQL Server Services from left pane and right click on SQL Server (SQLEXPRESS) and select Restart option.
- Now open SQL Server Management Studio.
- For this select Start → All Programs → Microsoft SQL Server 2008 R2 and click on SQL Server Management Studio.
- In this login screen you can write IP-Address,Port (i.e. 127.0.0.0,1989) as Server Name to login.
Notes:
- Don’t assign any port which is already in use by another application. For some security purpose, we block the inbound traffic on the following ports:
- 23 (Telnet)
- 135 - 139 (NetBIOS)
- 445 (NetBIOS)
- 497 (Backup Software)
- 389 (LDAP)
- 68 (DHCP)
- 1433 - 1434 (SQL Server)
- 1025 (MS Scheduled Task Endpoint)
- Make sure that you don’t assign any of these ports, otherwise, your application on these ports will not work.
- After changing the port for MSSQL Server, make sure that:
- You have made the necessary entry for that port in the firewall.
- If you are using WebsitePanel as your control panel, you must change the necessary settings of WebsitePanel also.