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?