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

Fix :: Reporting Service Error After Upgrade From MS SQL server from 2008 to 2012

Error Message Throwing Microsoft.ReportingServices.Diagnostics.Utilities....

How to configure MSSQL server default language configuration option?

Recently, we faced strange issue wherein one of our customers was capturing error messages coming...

How to use MSSQL Activity Monitor to find the most expensive query?

A slow and long running SQL query execution consumes much processor, memory, and disk of your...

How to Fix Error "Could not allocate space for object 'X' in database"?

Error Message Could not allocate space for object 'dbo.ABC_XYZ_XYZ'.'AB__ABC_XYZ__XYZ' in...

Microsoft SQL Server 2012 Recommendation

Microsoft SQL Server 2012 Express is a feature-rich yet FREE data management system. It is far...