We help IT Professionals succeed at work.

SQL Server TCP 1433 not binding

Medium Priority
1,139 Views
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!
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Commented:

Author

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.