Sql-server – MS SQL server port questions

sql server

I am very confused as tcpview shows sqlservr.exe listening on these ports 49371, 49373, 52732, but in the SqlServer Configuration Manager->SQL Native Client 10.0 Confgiuration->Client Protocols and properties of TCP/IP, the default port is 1433. Why is there no 1433 I see being listened on though? I find this very odd.

All my instances have a Dynamic Port set to some number as well. Any idea what is going on here? as I would like to connect my SQL Management Studio remotely but can't right now. I can connect the local one.

My end game is connectnig Visual Studio for entity generation and if I can get SQL Management Studio working, I think I can take it from there, but can't seem to get this to work.

EDIT: more notes. On my clean install machine, it is also not listening on port 1433. TCP is enabled and is order 2(shared memory is order 1). I am confused, how come a default install says default port is 1433 but no one listens on that port?

Version: 2008 R2 and just installed service packs.

Basic question though…how is this supposed to work? I have installed two instances locally and each one ends up with a dynmaic port and with tcpview, I confirm it takes up that dynamic port. This port 1433 everyone refers to, is that like a proxy instance that redirects to these dynamic ports or am I just supposed to change from dynamic port to fixed tcp port of 1433 myself?

What happens when you keep installing MS SQL instances? It can't put them all on port 1433, right? Was it supposed to put the first one on port 1433? What was your experience here?

thanks,
Dean

Best Answer

It could be that not sqlserver.exe is listening, but another process

Verify with netstat. My SQL says:

C:\Users\Administrator.ENV1>netstat -a

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    0.0.0.0:80             ENV1S08:0              LISTENING
  TCP    0.0.0.0:135            ENV1S08:0              LISTENING
  TCP    0.0.0.0:445            ENV1S08:0              LISTENING
  TCP    0.0.0.0:1433           ENV1S08:0              LISTENING
  TCP    0.0.0.0:2383           ENV1S08:0              LISTENING
Related Topic