• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1040
  • Last Modified:

SQL Server TCP 1433 not binding

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!
0
malkaj01
Asked:
malkaj01
1 Solution
 
enachemcCommented:
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
0
 
Nico BontenbalCommented:
0
 
malkaj01Author 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.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now