Viewing 15 posts - 211 through 225 (of 496 total)
Points don't matter. What matters is that people understand the concept. And I find that the Browser is actually one of the most misunderstood concepts in SQL to...
July 14, 2011 at 7:55 am
I did this (netstat -a -b -n) on a non-clustered box:
UDP 0.0.0.0:1434 *:* ...
July 12, 2011 at 10:51 am
Exactly. You don't configure it. SQL Server Browser for the DB engine listens on UDP 1434 and that cannot change because it is hard coded. The trick...
July 12, 2011 at 10:40 am
SanDroid (7/12/2011)
jeff.mason (7/12/2011)
"SQL Server Browser is not a clustered resource and does not support failover from one cluster node to the other. Therefore, in the...
July 12, 2011 at 10:22 am
mtassin (7/12/2011)
SanDroid (7/12/2011)
jeff.mason (7/12/2011)
July 12, 2011 at 10:15 am
SanDroid (7/12/2011)
jeff.mason (7/12/2011)
The answer (assuming you mean the DB engine and not SSAS) is ALWAYS UDP 1434. It may listen on UDP 1434 of IP_ANY, but still UDP 1434.
We...
July 12, 2011 at 10:11 am
SanDroid (7/12/2011)
jeff.mason (7/12/2011)
IP_ANY is JUST an address!IP_ANY just tells the system to use all IP addresses. It specifies nothing about the port.
As was already pointed out...
July 12, 2011 at 10:03 am
mtassin (7/12/2011)
Trey Staker (7/12/2011)
Thanks for the question. I learned a lot not only from the question but especially from the discussion. I did't know what IP_ANY was.
I'm beginning...
July 12, 2011 at 10:02 am
SanDroid (7/12/2011)
jeff.mason (7/12/2011)
From a client you connect to a named instance by instance name and not by port.
On the cluster, on both nodes, you close...
July 12, 2011 at 9:21 am
Gianluca Sartori (7/12/2011)
jeff.mason (7/12/2011)
From a client you connect to a named instance by instance name and not by port.
On the cluster, on both nodes, you...
July 12, 2011 at 9:09 am
SanDroid, let's put it this way:
From a client you connect to a named instance by instance name and not by port.
On the cluster, on both nodes, you close UDP 1434...
July 12, 2011 at 8:43 am
SanDroid (7/12/2011)
This whole post was just wrong. Not enough coffee yet. Content has been removed by Author.. 😛 😎
Ah, cool, then only pay attention to factual content in my...
July 12, 2011 at 8:23 am
SanDroid (7/12/2011)
Great question - It seems that the difference between an IP client application listening "PORT" and a Server IP listening port not well understood, especially on cluster server.
I don't...
July 12, 2011 at 8:09 am
Thinking about this more and I am more convinced. IP_ANY would make a difference if you had multiple instances on a cluster, a common thing. Each instance gets...
July 12, 2011 at 7:50 am
Viewing 15 posts - 211 through 225 (of 496 total)