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?