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

How to fix "Upgrade Error - Valid Database compatibility level and successful connection rule"?

One of our Windows VPS customers wanted to upgrade SQL Server from SQL Server 2008 R2 to SQL...

How to take MSSQL database offline or bring it online?

Sometimes, you come across to a situations when you are required to physically move the database...

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...

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...

Do you offer SQL schedule job?

Windows Shared HostingWe do not offer SQL server schedule job in our Windows shared hosting...