SQL Server TCP 1433 not binding

Posted on 2011-04-21
Last Modified: 2012-05-11
Hi Experts!

I just installed a new SQL 2008 SP2 instance and for some reason the server isn't binding to port 1433. I just did a plain SQL default install... nothing out of the ordinary.

If I run a netstat I can see that every time I reset the "SQL Server (Instance)" service the port assigned to sqlservr.exe gets changed. I also verify this by checking the ERRORLOG from the SQL instance.

Any ideas on how to get this bind to work?

Many thanks!
Question by:malkaj01
    LVL 12

    Accepted Solution

    SQL Server by default does not enable port 1433
    it only enables named pipes
    you have to manualy enable TCP comms on port 1433 from the server
    LVL 22

    Expert Comment

    by:Nico Bontenbal
    LVL 6

    Author Comment

    Thanks enachemc!

    Finally managed to get it configured!

    1) Open the SQL Server Configuration Manager
    2) Under SQL Server "Network Configuration/Protocols for INSTANCE"
    3) Enable TCP/IP
    4) Configure IP sets with the desired configuration

    Reset SQL Server INSTANCE service and you're good to go!

    Nicobo: You're solution isn't valid for a SQL 2008 SP2 installation.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
    This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
    To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now