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

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 Backup MSSQL Database from SQL Server Management Studio?

To take MS SQL database backup, first you need to connect to MS SQL Server through SQL Server...

Fix : Server Unable to load user-specified certificate. The server will not accept a connection

You may encounter this error when you attempt to start the MSSQL service. This error occurs when...