sql server 2008 r2 changing default port

Posted on 2012-08-21
Last Modified: 2012-08-28
The security folks are telling me I have to change the default port for my sql server from 1433.  I am not sure how to do this and also after I do it how will a client connect through a web interface to the sql database.  Any links that explain this for sql 2008 R2 would be appreciated.  Can I pick any port number or do I have to get a specific one or range I should pick from.
Question by:kdschool
    LVL 75

    Accepted Solution

    if your browser service is enabled (which i dont prefer to ) , then you dont really have to make any changes to the connection string otherwise, while the connection string should specify the port number ( servername : portnumber ) while making a connection.

    select any random port above 4000
    LVL 8

    Assisted Solution

    in the Protocal for SQlExpress ==> TCP/IP (enable) ==> properties (IPAddress tab)

    At the IPAll

    1.) fill blank at the TCPDynamic port.

    2.) fill 1433 at the TCP port.

    3.) restart SQL Server (SQLEXPRESS) of SQL Services Services again.

    4.) At the cmd DOS command. type the "netstat -na" . You will find TCP 1433

    refer URL :

    Author Comment

    So if I select 4010 and then in my connection string put that number in then it knows to find it with that port number?  would there be any impact if another server on the network had the same port number?

    Author Closing Comment

    Both answers were excellent.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Suggested Solutions

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now