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

Microsoft SQL Server 2014 Recommendation

The SQL Server 2014 Express is yet another feature-rich data management system from Microsoft....

How to Shrink Transaction Logs of Database in MS SQL?

This article will assist you to shrink/truncate the transaction logs of database in MS SQL...

Can I create unlimited MS SQL databases with unlimited database size?

Shared/Reseller Hosting: In Windows Shared/ Windows Reseller hosting you can create MS SQL...

How to fix an error "change password failed for login sa"?

Sometimes you receive following error while trying to reset MS SQL sa password via SQL Management...

How to Restore SQL Server 2012 Database Backup to SQL Server 2008?

Ideally, there is no way you can restore MS SQL Server 2012 database to SQL Server 2008 even if...