How to change the port for MSSQL Server 2008?

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:

  1. Login to your VPS.

  2. Go to Start → All Programs → Microsoft SQL Server 2008 R2 → Configuration Tools → SQL Server Configuration Manager.

    Open SQL Server Configuration Manager

  3. Select SQL Server Network Configuration.

  4. Select Protocols for SQLEXPRESS.

  5. Select Properties of TCP/IP Protocol.

    Open Properties of TCP/IP Protocol

  6. Move to IP Addresses Tab.

  7. Scroll Down and modify the Port number from IP ALL Section.

  8. Click on Apply and OK button.

    Specify New MSSQL Server Port Number

  9. Now restart SQL Server Services.

  10. For this, click on SQL Server Services from left pane and right click on SQL Server (SQLEXPRESS) and select Restart option.

    Restart MSSQL Server's Service

  11. Now open SQL Server Management Studio.

  12. For this select Start → All Programs → Microsoft SQL Server 2008 R2 and click on SQL Server Management Studio.

    Open SQL Server Management Studio

  13. In this login screen you can write IP-Address,Port (i.e. 127.0.0.0,1989) as Server Name to login.

    Specify New Details to Connect to MSSQL Server 2008

Notes:
  1. 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)
  2. Make sure that you don’t assign any of these ports, otherwise, your application on these ports will not work.
  3. 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.



  • 2 Users Found This Useful

Was this answer helpful?

Related Articles

Comparison of MS SQL Server 2016 Express Edition V/S. MS SQL Server 2016 Web Edition

Following is a brief comparison between MSSQL Server 2016 Express Edition and MSSQL Server 2016...

Choosing Between SQL Server 2012 and SQL Server 2014

If you are running SQL Server 2008 R2, you might be looking to upgrade your SQL server to...

Comparison of MS SQL Server 2014 Express Edition V/s. MS SQL Server 2014 Web Edition

Following is a brief comparison between MSSQL Server 2014 Express Edition and MSSQL Server 2014...

How to Increase the MS SQL Remote Query Timeout?

MS SQL Server has an option called Remote Query Timeout to specify the time (in seconds), a...

How to change password for MS SQL admin user?

Following tutorial will guide you to reset the MS SQL server sa user password. We assume that you...